Questions tagged [pgadmin]

pgAdmin is a graphical administration and development tool for PostgreSQL.

Filter by
Sorted by
Tagged with
0 votes
0 answers
31 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
83 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
38 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
149 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
44 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
122 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
34 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
35 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
121 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
166 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
166 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
139 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
326 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
  • 337
3 votes
1 answer
18k 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
0 votes
1 answer
76 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
0 answers
39 views

Can the keyboard shortcuts define of pgAdmin5 be customized?

I'm using pgAdmin5, I want to customize it's shortcuts, but I can't find out anywhere I can do it. Would you please tell me?
Leon's user avatar
  • 337
0 votes
2 answers
190 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
  • 337
2 votes
1 answer
2k 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
442 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
59 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
57 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
339 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
  • 243
0 votes
0 answers
750 views

How to connect PgAdmin4 to postgresql 9.5 database process running on AWS EC2 server

I have a postgres database running on a linux EC2 instance. I want to view the data inside the tables, and currently the only way I can do that is via command line on the host server by: sudo su ...
jabroni's user avatar
6 votes
2 answers
2k 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
1k 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
  • 209
1 vote
0 answers
538 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
512 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
808 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
0 votes
1 answer
5k 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
1 vote
2 answers
493 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
  • 225
2 votes
1 answer
4k 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
87 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
2k 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
268 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
  • 163
0 votes
0 answers
62 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
4k 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
14 votes
2 answers
9k 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
  • 141
0 votes
0 answers
518 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
3 votes
4 answers
24k 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
105 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
355 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
60 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
503 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
2 votes
1 answer
2k views

Creating a new table from another make it read-only in PGadmin interface

On PostgreSQL 11, I've created a new table from another, using a subquery : CREATE TABLE table2 AS (SELECT * FROM table1) As a result, table2 is created, but each column is in read-only mode within ...
Cupain's user avatar
  • 123
0 votes
1 answer
546 views

Determining primary key columns in PGAdmin, if the constraint name is generated by system

I am trying to learn a new schema of a PostgreSQL database, but it's unclear from looking at pgAdmin which columns per the tables constitute the primary keys. It appears that when the tables were ...
JLuu's user avatar
  • 101
0 votes
0 answers
132 views

How to change the Postgres hostname in pgadmin 4? [duplicate]

By default, the database hostname is localhost after the Postgres has been installed. Can the hostname be changed to something else like localhost\\abc? If yes, how can I do it in Windows/pgadmin? ...
hunterex's user avatar
  • 147

1
2 3 4 5 6