Hot answers tagged

48 votes
Accepted

pgAdmin 4 version 3 fails to open a second time

“Elephant” icon menu When pgAdmin is running, an elephant icon menu appears. Look at the upper right corner of the screen. The elephant refers to Slonik, the Postgres mascot. Choose New pgAdmin ...
user avatar
39 votes

Binary path in the pgAdmin preferences

Configure pgAdmin->Paths->Binary paths and set "PostgreSQL Binary Path" as shown in the screenshot. Depending on your OS and installation details, the binaries may be located elsewhere. Try `which ...
user avatar
  • 491
29 votes

Binary path in the pgAdmin preferences

Select "Servers" item. Select "Configure PgAdmin" Enter to local path Postgresql "bin" folder. On OSX the path is /Applications/Postgres.app/Contents/Versions/latest/bin On Mac OSX Sierra the path ...
user avatar
26 votes

save/export PGAdmin server list configuration settings

Under Windows, pgAdmin4 stores the server list in the users directory in a SQLLite 3 format. Here: %UserProfile%\AppData\Roaming\pgAdmin\pgadmin4.db
user avatar
  • 361
23 votes
Accepted

What is the Maintenance DB asked by pgAdmin?

It is worth mentioning that you are free to define any existing database in the cluster as "Maintenance DB". You are not limited to the options suggested by the interface, which are just typical ...
user avatar
23 votes
Accepted

PostgreSQL "size of temporary files"

I found nothing in the pgAdmin documentation, but the source code reveals the query behind these entries (added for Postgres 9.2+): It boils down to: SELECT temp_files AS "Temporary files" ...
user avatar
20 votes
Accepted

PostgreSQL, display role members

To get all members of all roles: SELECT r.rolname as username,r1.rolname as "role" FROM pg_catalog.pg_roles r JOIN pg_catalog.pg_auth_members m ON (m.member = r.oid) JOIN pg_roles r1 ON (m.roleid=r1....
user avatar
17 votes
Accepted

Postgres: Difference between Tuples inserted and Live tuples

This nomenclature all comes down to knowing about MVCC, or Multi-Version Concurrency Control, which is how PostgreSQL handles transactions and concurrency. When you update or delete a row, doesn't ...
user avatar
  • 3,351
16 votes

How do I specify that a column should be auto-incremented in pgAdmin?

If you want to do this in PGAdmin, it is much easier than using the command line. It seems in PostgreSQL, to add a auto increment to a column, we first need to create a auto increment sequence and add ...
user avatar
14 votes

What is the Maintenance DB asked by pgAdmin?

From the docs: The maintenance DB field is used to specify the initial database that pgAdmin connects to, and that will be expected to have the pgAgent schema and adminpack objects installed (...
user avatar
  • 32.7k
14 votes

How do I specify that a column should be auto-incremented in pgAdmin?

This is pretty easy in pgAdmin 4. First, add a column to your table, then click the little edit icon: Then go to Constraints and select the Identity type: Save your table and the column will auto-...
user avatar
  • 241
14 votes
Accepted

PgAdmin 4 installation on Debian/Ubuntu

There are instructions on the pgAdmin site how to install with pip: https://www.pgadmin.org/download/pip4.php But there is no official Debian Package (.deb), yet. A request for packaging is pending: ...
user avatar
14 votes

PgAdmin III -- how to merge output pane and query pane

Go to File-> Reset layout This will merge the outputpane to the bottom of the screen.
user avatar
  • 141
13 votes

PostgreSQL "size of temporary files"

According to: http://www.postgresql.org/message-id/BLU0-SMTP179B92C5102247CD961A4B3CF2A0@phx.gbl The temp counter (files and space used) shows a total of all temp files used since probably cluster ...
user avatar
13 votes

How to execute multiple statement in PgAdmin 4 like we do in Sql Server/Oracle?

pgAdmin (both III and 4) execute both statements. For the first one, it just discards the output, unless there is an error. You can actually chain as many statements as you want: -- We create one ...
user avatar
  • 12.5k
11 votes

Retrieving all PK and FK

Based on Erwin solution: SELECT conrelid::regclass AS "FK_Table" ,CASE WHEN pg_get_constraintdef(c.oid) LIKE 'FOREIGN KEY %' THEN substring(pg_get_constraintdef(c.oid), 14, position(')' in ...
user avatar
11 votes
Accepted

Why do my queries take longer together than when I run them separately?

Debunking If you are doing all your updates in the same transaction, each of them will have to work an increasingly bigger set of (physical) tuples. See the following example: CREATE TABLE explode (...
user avatar
  • 29.1k
11 votes
Accepted

PostgreSQL 12: column proisagg does not exist

The query is hard-coded into pgAdmin III, and you cannot change it. These columns have been removed in v12 because they are no longer useful. pgAdmin III has been out of support for years. Use ...
user avatar
10 votes

Retrieving all PK and FK

No need to parse pg_get_constraintdef(), just use columns of pg_constraint table to obtain other details (the docs). Here constraint_type can be: p - primary key, f - foreign key, u - unique, c - ...
user avatar
10 votes

How to uninstall pgAdmin4 on Ubuntu 16.04?

sudo apt autoremove pgadmin4 works for ubuntu version 18.04
user avatar
9 votes

Is there a timeout option for remote access to PostgreSQL database?

A PostgreSQL server connection dropping after 10-15 minutes is almost certainly being caused by a state-tracking firewall (possibly using Network Address Translation (NAT)) between the client and the ...
user avatar
9 votes

See entire string from a lengthy text field in pgAdmin?

Open pgAdminIII, Select your database, Use the Magnifying Glass button, i.e. "Execute arbitrary SQL queries" Instead of running your query using the green triangle "Execute Query", choose the button ...
user avatar
9 votes
Accepted

PGAdmin 4 - server status / view log file

I have followed the guide here to use a foreign data wrapper so I can access the log file through SQL. First, create the extension: create extension file_fdw; Next, set up postgres.conf to support ...
user avatar
  • 281
9 votes
Accepted

Kill connection in pgadmin4 Postgresql

pgAdmin III can show information about all connections by using the Tools > Server Status. This option shows a window with four panes: Acitivity (showing all connections, with PID, application ...
user avatar
  • 12.5k
8 votes
Accepted

PGAdmin III Server Status Error: Could not read directory "pg_log" No such file or directory

Your client (Windows) is running on a different machine than your server (Ubuntu). You cannot read the remote file system. Inspecting the logs only works if your client is on the same machine (or has ...
user avatar
8 votes
Accepted

Error 42P01: relation does not exist

What you had originally was a correct syntax - for tables, not for schemas. As you did not have a table (dubbed 'relation' in the error message), it threw the not-found error. I see you've already ...
user avatar
  • 29.1k
8 votes
Accepted

Where can I see the exact row count of a table in pgAdmin III?

Two lines below the estimate you highlighted we can see: Rows (counted) not counted Right-click and choose Count from the context-menu to get the current count right there. Be aware that the count ...
user avatar
8 votes

Create pgAdmin database on local machine

PgAdmin is just a tool to work on existing database. @FabrizioMazzoni is right - you have to install PostgreSQL server first, and the you can use PgAdmin to work on it. New Server Registration is a ...
user avatar
  • 401
8 votes
Accepted

pgAdmin 4, no built-in SSH tunnel config?

UPDATE: SSH Tunneling is now available as of version 3.1 - https://www.pgadmin.org/docs/pgadmin4/development/release_notes_3_1.html Original answer: Looks like they plan on having it for v2.0, ...
user avatar
8 votes

pgAdmin 4 version 3 fails to open a second time

Update For best solution, see Answer by Burmistrov. Web browser As for launching the app causing a page to open in your default web browser, Yes, that is the new normal. Per an email on the psgsql-...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible