Questions tagged [pgadmin]
pgAdmin is a graphical administration and development tool for PostgreSQL.
268
questions
0
votes
0
answers
78
views
pgadmin connection to server error
I'm having a server-connection-error on pgadmin dashboard. I kept having a connection timeout error after prompting me to enter the password for user "postgres" after clicking on PostgreSQL ...
0
votes
1
answer
73
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
0
answers
12
views
Why pgAdmin run my job every 2 minutes when there is no job schedule end date?
I have a testing job that I create using pgAgent interface, and then I insert the schedule using this query:
INSERT INTO pgagent.pga_schedule (jscjobid,
jscname,
jscdesc,
jscenabled)
...
0
votes
0
answers
23
views
Groups for local users in pgadmin4 (web server mode)
I have a containerized setup of pgAdmin4 V8.5 in server mode running.
Does anyone know if I can create groups for local users in pgadmin4 in web server mode and set privileges for them?
Basic idea
To ...
0
votes
2
answers
24
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 ...
0
votes
0
answers
76
views
Block access from pgAdmin to Postgres in kubernetes
We are trying to setup a pgAdmin but want to avoid that the root user could connect and create, update or delete anything.
We have create a new readonly-user for this case and this works fine. But it ...
0
votes
0
answers
237
views
Can't backup postgres database
When trying to backup a postgres db in the pgAdmin UI it's throwing an error with no reason given in the processes panel
So I then tried to do a pg_dump in the administrator cmd with this command
...
1
vote
1
answer
183
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/...
1
vote
0
answers
490
views
Remove server from pgAdmin4 server list
In pgAdmin4, I'm trying to delete "PostgreSQL 15" from my server list since I installed V16 and removed all V15 files. (Windows 11, PostgreSQL V16, pgAdmin v7.8)
I can "Remove" the ...
1
vote
1
answer
46
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
...
1
vote
0
answers
190
views
Can not enter a new master password in pgadmin4 v5.7
I am working with two versions of pgAdmin4, v5.7 and v7.4. With v7.4 I don´t have any trouble with connecting to my local or remote servers, however with v5.7 I have encountered problem with logging. ...
0
votes
1
answer
82
views
postgres db 'function mul(double precision) does not exist'
I am currently facing a problem on an postgres database. The db server is a data warehouse for a software we are using. For every tenant in the software system there is a database on the postgres ...
0
votes
1
answer
66
views
Seed pgAdmin roles with Active Directory groups when using Docker
I want to setup a pgAdmin instance for our team using the Docker deployment. As our organization uses Active Directory, I'd like to assign the pgAdmin User role to a specific AD group when starting ...
1
vote
0
answers
144
views
PgAdmin4 cant find pgagent as an extension MacOS
I installed pgagent using EnterpriseDB's installer on MacOS. However, pgagent doesn't show up in pgadmin after the installation. Even when I try to manually add pgagent as an extension, I get the ...
0
votes
1
answer
261
views
Binary path in pgadmin
I am running pgadmin via Docker desktop. I am unable to restore a sql file in the database. I get the following message - "Please configure the PostgreSQL Binary Path in the Preferences dialog.&...