Questions tagged [pgadmin]

pgAdmin is a graphical administration and development tool for PostgreSQL.

Filter by
Sorted by
Tagged with
0 votes
1 answer
20 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
22 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
49 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
41 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
40 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
37 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
0 votes
3 answers
137 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
  • 285
3 votes
1 answer
14k 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
43 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
23 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
  • 285
0 votes
2 answers
52 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
  • 285
2 votes
1 answer
1k 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
251 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
35 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
49 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
266 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
1k 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
  • 233
0 votes
0 answers
589 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
1 vote
1 answer
756 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
  • 199
1 vote
0 answers
449 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
450 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
  • 101
1 vote
0 answers
527 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
3k 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
1 answer
322 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
1 vote
1 answer
3k 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
82 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
5 votes
1 answer
1k 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
257 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
  • 153
0 votes
0 answers
55 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
3k 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
7k 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
423 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
19k 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
89 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
295 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
52 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
438 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
458 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
105 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
  • 127
1 vote
1 answer
9k views

Restoring a backup gives "Failed exit code 1"

I'm migrating from Heroku's Postgres to AWS RDS. I've generated a pg_backup.dump file from Heroku, installed Postgres on my local machine, launched PGAdmin, configure remote AWS server, and used the ...
rcx935's user avatar
  • 113
0 votes
1 answer
490 views

Is there a native(none-web) GUI client of pgadmin4?

I don't like web-based GUI, so I only installed the pgadmin4-desktop package for my Kubuntu 20.04, instead of pgadmin4-web and pgadmin4. According to the offical web page of pgAdmin4, A desktop ...
Leon's user avatar
  • 285
2 votes
0 answers
238 views

How can I change the password for pgadmin in Windows?

I want to know how I can change the password of pgAdmin, the same one that is created when it is installed in Windows The point is that I have not forgotten, but for personal reasons I want to change ...
user avatar
0 votes
1 answer
5k views

remove postgres server from local machine

I know this is a real beginner question. But nevertheless I'm really confused:/ I wanted to have a clean installation of postgres on my ubuntu laptop. So I tried to delete everything related to ...
Lenn's user avatar
  • 101
3 votes
0 answers
1k views

pgAdmin 4, force "The application has lost the database connection:"

Whenever I put my computer in sleep mode pgAdmin 4 loses the connection to the remote Postgresql database (and that's fine). When I start up the computer again I have two options. Either restart ...
grofte's user avatar
  • 131
1 vote
1 answer
796 views

Connections remain active even after terminating the session in Postgres

Yesterday, I added the pldbgapi extension in my Postgres DB to debug a function. I was using PgAdmin for debugging the same. But today, when I tried invoking a simple query, it was taking a lot of ...
Sunny's user avatar
  • 133

1
2 3 4 5 6