Questions tagged [pgadmin]
pgAdmin is a graphical administration and development tool for PostgreSQL.
271 questions
1 vote
1 answer
33 views
Granting Monitoring privileges to a user in PostgreSQL
I am creating a new user and granting them the pg_read_all_stats privilege so they can monitor all pg_stat_* views. However, when I monitor pg_stat_activity through this user, other users' operations ...
0 votes
1 answer
85 views
How do you add server connections on ubuntu version of pgAdmin?
I was sitting on pg14 for some time, while the postgresql package updates accumulated all the way up to 17, so the result of pg_lsclusters looks like this: Ver Cluster Port Status Owner Data ...
- 288
1 vote
1 answer
462 views
Running Postgres on windows AND WSL, connect pgadmin to both
I have a webapp I'm developing using Symfony 6.4 and Postgres 15. My Employer has given me a windows machine that is locked down and I can not get raised privileges. Anytime i want anything done i ...
- 21
1 vote
1 answer
163 views
Why listen_addresses not changing in PostgreSQL?
I'm trying to ENABLE remote client access on my PostgreSQL 12 database (Ubuntu 20.04 LTS). I've changed postgresql.conf on both paths /var/lib/postgresql/12/main and /etc/postgresql/12/main this way: ...
- 11
0 votes
1 answer
612 views
Existing data directory error in postgres installation
This message is what I've been getting while installing a new Postgres. I want the data to be stored in a new directory and not the existing one. An existing data directory has been found at C:\...
0 votes
2 answers
66 views
With an older version of PgAdmin, when creating a database, we cannot find where to set IS_TEMPLATE
We are using PgAdmin connecting to an instance of PostgreSQL. With PgAdmin, in the context of Servers > [the_server_login] > Databases > Create > Database, we input the necessary ...
- 57
1 vote
1 answer
448 views
pgAdmin 4 ... is not present in the table
Hello Here is my erd and the below my creating table codes; -- This script was generated by the ERD tool in pgAdmin 4. -- Please log an issue at https://redmine.postgresql.org/projects/pgadmin4/...
- 13
1 vote
1 answer
56 views
Specific query gives me trouble
I'm supposed to run this query in PGadmin: SELECT n2.cpr, n2.adresseringsnavn, n2."fødselsdato" AS foedselsdato, n2.morcpr, n1.mor_navn, n2.farcpr, n3.far_navn ...
