Skip to main content

Questions tagged [pgadmin]

pgAdmin is a graphical administration and development tool for PostgreSQL.

Filter by
Sorted by
Tagged with
0 votes
0 answers
77 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 ...
Alli Grace's user avatar
0 votes
1 answer
71 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:\...
Alli Grace's user avatar
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) ...
samsoxu's user avatar
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 ...
krytopes's user avatar
0 votes
2 answers
23 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 ...
Mike's user avatar
  • 13
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 ...
user6266369's user avatar
0 votes
0 answers
236 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 ...
user avatar
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/...
bershinn's user avatar
1 vote
0 answers
489 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 ...
Rick's user avatar
  • 11
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 ...
Maja Thuren Jørgensen's user avatar
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. ...
odGnol's user avatar
  • 11
0 votes
1 answer
80 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 ...
chris000r's user avatar
  • 103
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 ...
mu88's user avatar
  • 103
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 ...
champa's user avatar
  • 11
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.&...
Rambo John's user avatar
0 votes
2 answers
428 views

PostgresDB - Updating a Table from a different Server

I have a Database on a server (external) that has multiple tables that I have a connection to. I have created a select query that does various joins and that gives me the desired final view of this ...
DataVick's user avatar
0 votes
0 answers
173 views

pgAgent jobs do not run on databases other than default "postgres"

I am having a problem where I can only run pgagent jobs in default postgres database. I have a remote connection to another server and want to run pgagent jobs in a different database. Do I need to ...
PandelisM's user avatar
1 vote
3 answers
614 views

Why is NOT there "pg_get_tabledef" that is equivelant of "pg_get_indexdef" for tables in PostgreSQL?

I have searched the docs of PostgreSQL and Google, but I haven't found the function pg_get_tabledef, while pg_get_indexdef exists. There's no pg_get_tabledef? Maybe it's too difficult to be ...
Leon's user avatar
  • 357
3 votes
1 answer
20k views

pgAdmin 4 v 7.1 not loading after trying everything

I am having serious problems getting pgAdmin 4 to load. I'm running on Windows 10. Please see attached screenshot. I have naturally tried to troubleshoot this problem myself. I have followed ...
Gregory C's user avatar
  • 161
0 votes
1 answer
107 views

pgAdmin 4 Database lost after filed start-up - how do I recover the connection?

After a few months away from pgAdmin 4, I attempted to open the program - first time, it failed, second time it started up - but the database, called 'athome4' was missing. I checked in QGIS and the ...
Anthony Avengerland's user avatar
0 votes
2 answers
499 views

How to correctly select multi-columns from a return of a function in Postgresql?

I have hundreds of tables with same structure in a Postgresql-11 db, and I need to perform a same statistics on each of them. Since the real statistics logic is very complex, in order to simplify my ...
Leon's user avatar
  • 357
2 votes
1 answer
3k views

How can I exclude some tables when using pg_restore?

I created a backup file from one database and I try to copy it to a different database, under the same schema, while excluding two large tables. I tried this command : pg_restore --host=violacredit....
Dor Cohen's user avatar
2 votes
0 answers
649 views

How do I change the timezone of pgadmin?

I have PGAdmin hosted in server mode (container) on my server. In the "server activity" section, the time is being displayed in UTC. How do I make PGAdmin display time in my local time? I ...
berinaniesh's user avatar
1 vote
0 answers
93 views

Why can psql commands not be executed from PGAdmin "Query Editor"

From the PGAdmin "Query Editor" I have tried, in the spirit of this SE post, to embed psql commands in my SQL scripts: For instance, \set myTempVariable 42; SELECT * FROM mytable WHERE age= ...
Owen's user avatar
  • 111
1 vote
0 answers
59 views

Postgres: copy from 2 different DBs for identical tables

I have two identical DBs, under the same port and host. (they both postgres DBs and on AWS) I want to create a script\write any query (even though it is not possible to create a query that use data ...
Dor Cohen's user avatar
1 vote
0 answers
427 views

Unable to create and install pgAgent service

I'm trying to install pgAgent on my device. During the installation using the stackbuilder, the last step requires me to add the operating system username and password as below: However, after ...
Abhinav Shenoy's user avatar
2 votes
2 answers
2k views

How to interpret "transactions per second"?

Short version: When I execute one transaction in IntelliJ, the "transactions per second" graph increases by 10 tx/sec - I only expect it to increase by 1. So, it seems that my understanding ...
TmTron's user avatar
  • 253
6 votes
2 answers
3k views

Is pgAdmin adding query time overhead?

I just wrote a long question about what I did to optimize a rather simple query that takes much longer than I wish it would. I kept querying with pgAdmin. And then I made the query simpler and simpler ...
EasterBunnyBugSmasher's user avatar
2 votes
1 answer
2k views

PostgreSQL: how to query statistics of a step in pg_agent?

PgAdmin shows statistics of each run of a step of pg_agent (job). The list details the run ID, status, result, start & end & duration. The following is how it looks: How to get it by query ...
Rino's user avatar
  • 219
1 vote
0 answers
624 views

Avoid pgAdmin4 timeout that prevents disconnect

Connecting to PostgreSQL servers through pgAdmin4 will time out after some short period of time (2-5 min). When this happens I cannot reset the connection or disconnect from the server. The interface ...
Conor's user avatar
  • 111
0 votes
0 answers
604 views

Suddenly pgadmin doesn't allow me to select from a table

I created a database, and created a user to access it via Python. Postgres user is an owner. I didn't access the database for a couple of weeks (before everything was working), and now when I want to ...
mimic's user avatar
  • 111
1 vote
0 answers
1k views

backup a single user , password and privileges from postgresql

I am moving a database user form one postgresql server . I need to take backup of the user name , password and privileges and restore into another pgsql server. I looked into the documentation and ...
sherin's user avatar
  • 111
0 votes
0 answers
2k views

postgres without installation on Windows- Fatal error: The pgAdmin 4 server could not be contacted

Trying to run pgAdmin after setting up postgres without installation like described [here][1] [1]: https://stackoverflow.com/a/26441939/15307393 I am getting the fatal error The pgAdmin 4 server could ...
erik-stengel's user avatar
1 vote
1 answer
6k views

pgAdmin portable without installation

Is there a possibility to run pgAdmin on Windows without any installation e.g. on a USB-drive?
erik-stengel's user avatar
2 votes
2 answers
950 views

Can I have two Query Editor panels in pgAdmin?

Can I have two different Query Editor panels in PGAdmin, side by side? If not, is there another way of avoiding the pain point that's making me want two panels? That is: When I'm building up a complex ...
baudot's user avatar
  • 235
2 votes
1 answer
5k views

Why do I see the timezone offset displayed in PgAdmin, for a timestamp with timezone

I'm using PgAdmin 4 v6, and for some timestamp data with data type of timestamp with time zone, I'm seeing it in PgAdmin like this: 2022-03-06 16:11:33+04 Why is the +04 being displayed? I've looked ...
Chris Halcrow's user avatar
1 vote
0 answers
91 views

How to close connection after doing a "View/Edit" of a table

In pgAdmin 4, after I right-click on a table and choose "View/Edit data", I cannot figure out how to close that new connection. If I try to "Delete/Drop" the database, it says: ...
John Pankowicz's user avatar
6 votes
1 answer
3k views

How do I adjust the table link endpoint in PgAdmin's ERD tool after autogenerating it from an existing database?

I can move the lines themselves around, but I can't move the endpoints, which cause the lines to overlap. The only way to understand which relationship is being referenced is by hovering over the ...
Josh Mathews's user avatar
1 vote
0 answers
283 views

How do I copy a table from one database to another? Dump files come out empty

I am trying to "dump" a table to a file, copy that file to a different host and restore the table on a database. My (first) problem is that I cannot dump the table data. I use this command: ...
birgersp's user avatar
  • 175
0 votes
0 answers
73 views

Problem with column being forced as primary-key

I am new to postgresql and having some problem when creating a table using pgadmin gui. I define a column named id as integer primary-key and another column named idchat as integer not null. But, ...
Tales Costa's user avatar
2 votes
2 answers
5k views

Is it possible to open an SQLite database inside pgadmin?

I was trying to find a way of opening SQLite databases inside pgadmin and I found this StackOverflow question where one solution points to importing the SQLite database inside PostgreSQL, and the ...
raylight's user avatar
  • 123
15 votes
2 answers
11k views

What does it mean when a session is highlighted in red in the PgAdmin dashboard?

I've noticed sessions being highlighted in red recently though this never occurred in the past which leads me to believe it is a new feature. It appears to only occur on hanging queries. I looked ...
joepcash's user avatar
  • 151
0 votes
0 answers
617 views

pgAdmin4 Doesn't Start After PostgreSQL Config

I tweaked the hba_conf file to use username and password authentication rather than ident on local and ipv4 local connections and then I noticed that pgAdmin doesn't start up at all. I'm not sure if I ...
StackMatch's user avatar
4 votes
4 answers
28k views

how to fix "your account is locked. please contact admin" issue in postgresql when login

I'm new to PostgreSQL.I'm using postgreSQL locally. I used it last time without any issues. Now, when I try login with my login credentials it shows the account is locked message all the time.
user avatar
2 votes
1 answer
112 views

In PgAdmin, what does `[...]` refer to in a result set?

Sometimes my query results include a cell containing the pattern [...]. When I export such results, they render as a blank string. However, when I try to filter on them with where column_b = '', there'...
data princess's user avatar
2 votes
0 answers
438 views

pgAdmin 4 - Can't do anything after connection lost

I'm using pgAdmin 4.5 on Windows 10. When I connect to a database, things going well. Then after some idle time, pgAdmin says "The connection is lost", then refuse to do anything, including ...
Romulus Urakagi Ts'ai's user avatar
1 vote
0 answers
61 views

PSQL 9.6 - OR query is much slower on joined table

We have a production POSTGRES 9.6 db with about 100M records (LOYALTY) and new table (has just 4 data as of now) "INFO" Full index name on table loyalty indexname "loyalty_activated_at&...
zcahfg2's user avatar
  • 111
1 vote
0 answers
2k views

How do I run pgadmin in a web browser by default?

I'm running pgadmin 5.4 on macOS Big Sur. When I open the application, pgadmin launches in Desktop Mode, as a standalone app. My goal is to force pgadmin to run within a browser instead, but I'm ...
Chris Perry's user avatar
2 votes
0 answers
2k views

Obtain INSERT statements as a query result

Using pgAdmin on my local machine, I am able to view table data and also export the INSERT statements for the table using "backup" button (Plain format, Use column inserts, Use Insert ...
firstpostcommenter's user avatar
0 votes
1 answer
603 views

Why does querying a PostgreSQL database have an overhead of a few dozens of milliseconds?

Everything is in the same place, same local computer. Whenever my Go application as well as pgAdmin 4 queries the PostgreSQL database, it takes at least a few dozens of milliseconds, however short the ...
Константин Ван's user avatar

1
2 3 4 5 6