Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

pgAdmin is a graphical administration and development tool for PostgreSQL.

0
votes
0answers
34 views

pgadmin4 — Query Tool Initialize Error

I know this question has been asked multiple places, but I still CANNOT find an answer that works in my case. Every time I open pgAdmin4 in IE and log-in, I try to load the query tool or create a new ...
1
vote
1answer
22 views

how to extract difference between timestamps

SQL greenhorn alarm: I have a table with timestamp information (44 rows) and I now would like to calculate and extract the delta between any two consecutive rows. How can I do this? I select my data ...
0
votes
0answers
26 views

PGAdmin4 Browser: Autocomplete not working

I am using PGAdmin4 on my Firefox Browser(Mac). I am looking for auto-complete feature but could not get it work. The documentation says that the shortcut for auto complete is "Ctrl+Space" but it ...
1
vote
0answers
101 views

pgAdmin Unable to connect to server via SSH Tunnel (nothing in logs)

Using pgAdmin to connect to postgres via SSH Tunnel is giving me the following error. Unable to connect to server: server closed the connection unexpectedly This probably means the server ...
1
vote
1answer
502 views

Getting Failed (exit code: 1). when running restore DB from a .tar file in pgAdmin4 postgresql 10.5 [closed]

I'm taking an intro to SQL course and I can't get my very first database loaded. I have a file dvdrental.tar, I create a new database dvdrental > right click > Restore > Select File > Pick "Data" ...
0
votes
2answers
36 views

Will my query continue to execute after I shut off my computer

I am running a very expensive query that I executed via pgAdmin 4 which is installed on my laptop. I am executing the query on a cloud server. The message that I see is 'Waiting for query execution ...
0
votes
1answer
27 views

What are current values in PG admin configuration editor for postgresql.conf

I am tuning a postgresql.conf file and here is what is shown in PG admin configuration editor What does the current value corresponds to? For the shared buffers (red line), what is the value there?
1
vote
1answer
75 views

How to use postgresql service file in pgadmin4

My service file is working well in PgAdmin3 and in QGIS. I'm trying to use the same service file in PgAdmin4. But no luck, I still have the same message: Unable to connect to server: definition of ...
1
vote
0answers
72 views

In pgAdmin 4, show multiple lines of a TEXT column

A have a TEXT column in which the values contain newlines. When I query the column in pgAdmin, I only see the first line of each value. Can I make pgAdmin show multiple lines in a cell?
0
votes
0answers
129 views

Can't connect to postgresql database remotely after successful connection to instance

I don't think this is the normal issue, and frankly I'm not really sure what could be causing this behavior. I have a box running arch with a postgresql instance running on it. When I'm on the box ...
0
votes
0answers
43 views

The “run time” in pgadmin4

Is there any way to display how long time a query have been running in pgadmin4? I can see afterwards in the message tab, but I would like to see how long time a query have been running, while it ...
10
votes
3answers
4k views

pgAdmin 4 version 3 fails to open a second time

I just installed pgAdmin 4 version 3.0.0 for macOS Sierra, replacing the pgAdmin that came bundled with Postgres 10.3 running locally on the same Mac. I opened the pgAdmin 4.app app icon, which ...
0
votes
0answers
35 views

Is it possible to restrict user database visualization on postgres?

I created a user that can only preform operations to a single database on my server. Nevertheless using pgadmin he can still see all the databases present on that particular server even if he can't do ...
1
vote
1answer
1k views

Postgres: Difference between Tuples inserted and Live tuples

Many apologies in advance, but I was not able to find this out myself: What is the difference between live tuples and tuples inserted in postgres statistics? There's this post, but it doesn't answer ...
-2
votes
2answers
2k views

Linux: I want to see a list of Postgres databases via the terminal

I have connect database using following command sudo -i -u postgres . And after i have tried \l and \d too, to views of list of all available database its not working d:command not found and l:...
0
votes
2answers
4k views

How to uninstall pgAdmin4 on Ubuntu 16.04?

I successfully installed pgAdmin4 with pip install pgadmin4-2.0-py2.py3-none-any.whl But afterward, pip list doesn't show anything related to pgAdmin, so I don't know what argument to pass to pip ...
1
vote
0answers
52 views

Where is the pg_hba.conf file amendment on pg_admin 4?

On pg_admin3, you have an option to change / amend the pga_hba.conf file as you can see here I tried to find a similar option in pg_admin 4 but to no avail. Has the option disappeared?
0
votes
0answers
128 views

understanding index statistics in pgadmin

I am trying to get an understanding of indexes. Below are some index statistics for one of my indexes in pgadmin. I am attempting to understand the difference between a scan,tuple read,tuple fetched,...
0
votes
1answer
701 views

pgAdmin 4 - Can't Create Script on a database [closed]

When I try to CREATE Script on a database I want to use, there is no CREATE Script item in the context menu. But CREATE Script looks fine on another database. I can select it and it works fine. ...
0
votes
2answers
91 views

How can I disable the notifications shown at bottom right corner in pgAdmin 4?

The notification window at bottom right corner is pesky. Is it possible to disable it?
3
votes
1answer
242 views

Query returned successfully when obvious error should occur

I have just installed postgresql and pgadmin on my Windows machine. The problem is that whatever I enter in query window, it results with message: Query returned successfully in XX msec. Even, ...
0
votes
1answer
383 views

Handling differences between MS-SQL and PostgreSQL money datatypes [closed]

This is a follow-up/ to my previous question Is it possible to insert un-formatted data for money data type in PostgreSQL I could read money data by typecasting it into numeric SELECT '52093.89'::...
1
vote
0answers
234 views

postgresql connection with pgadmin4 shows all databases on the same domain

I have created 2 postgresql databases, 1 in the main domain and another one in the subdomain of the same domain. they both have different username and passwords. I have logged in with pgadmin 4 to ...
-3
votes
1answer
125 views

pgAdmin is consuming too much ram in Server

I am a developer yesterday I have noticed something odd with my server as pgAdmin is taking 11.2g of Ram I got Nagios alert for that is it normal Please help. another image o/p for top -c -b -n 1 -u ...
1
vote
0answers
802 views

How to backup some selected tables, but not all, in pgAdmin 4?

In pgAdmin 3, the dialog to perform a backup allowed you to check and un-check the tables you wanted to be part of your backup. In pgAdmin 4, either I am unable to find this feature, or it is not ...
3
votes
1answer
735 views

Error creating server with pgadmin

I´m using pgadmin and I´ve created a server, when trying to connect I get the following error: Have you ever seen this problem? Many thanks
3
votes
1answer
86 views

Getting nice PostgreSQL pgAdmin-style DDL

In pgAdmin 3 (and pgAdmin 4 if you're prepared to wait longer) the DDL for the currently selected database object is shown in the main panel, along with corresponding triggers, constraints, etc, all ...
1
vote
1answer
1k views

unable to create schema on amazon rds for postgres

I'm trying to create a schema on a postgres instance located on Amazon rds. That schema would be used to import data from an existing schema built on a local db. Issue is I do not have permissions ...
2
votes
1answer
927 views

AWS RDS Postgres pg_hba.conf auth-method

I'm starting to use Amazon Web Service's Relational Database Server product (AWS RDS) and want to confirm I have not made a security blunder. My configuration: Postgres Publicly accessible Inbound ...
3
votes
3answers
643 views

PgAdmin III — how to merge output pane and query pane

Somehow, I clicked on something the wrong way and popped the output pane out into a separate window from the query pane. I've tried restarting my computer, restarting PgAdmin III, but nothing fixes it....
1
vote
1answer
331 views

Postgresql: newly created database does not exist

Recently I faced strange error. I'm running Postgresql behind pgBouncer. I created new database in pgAdmin (connected through pgBouncer). It shows up on the list, but when I try to select it I get ...
1
vote
2answers
155 views

Problem with foreign key between 3 tables. (PgAdminIII)

I'm using pgAdmin III for PostgreSQL but I have a problem with foreign keys between 3 tables. My tables are: Locale with a primary key IDnegozio (integer type, no need to make it serial type) Orario ...
3
votes
1answer
5k views

Kill connection in pgadmin4 Postgresql [closed]

Can you tell me how to kill connection in pgadmin 4 web postgresql without executing any scripts? How can I limit the number of connection to database in order to kill the active connection (My case ...
3
votes
1answer
582 views

Cannot open `pg_hba.conf` in pgAdmin III

I am running: version ----------------------------------------------------------------------------------------------------- PostgreSQL 9.4.11 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8....
2
votes
1answer
3k views

Client application disconnects from database/s it is connected to after 10 minutes of inactivity

When working with pgAdmin 4 (and actually, several other programs that act as clients to the database), the connection to the server disconnects after some 10 or 15 minutes of inactivity. One coffee ...
1
vote
1answer
327 views

Error with pgAdmin III and pg_hba.conf

I have a problem with my Pgadmin3.. I used to use the last year, but this year I can't connect with the localhost server with pgadmin This is the message error: FATAL: no pg_hba.conf entry for host "...
3
votes
0answers
491 views

Problem: Remote connection with pgAdmin4

I just installed the Java and PostgreSQL environment on a server (for remote testing) CentOS 7 From the command line using ssh would seem that there are no problems in the sense that I can access the ...
0
votes
1answer
2k views

Getting 'Connection refused' after installing PostgreSQL and PG Admin 4 [closed]

I had installed PostgreSQL Server on a machine. I had installed PGAdmin4 on another machine but when trying to connect, I am getting error on the startup of the PG Admin4 'Connection refused'. How ...
3
votes
3answers
12k views

How to Backup/Restore in PostgreSQL pgAdmin 4?

So I feel like this is something that should be very basic and easy to do, maybe I'm just not doing things correctly. I want to do the equivalent of SQL Server backups. I want to create the ...
2
votes
1answer
3k views

How to uninstall PostgreSQL (and pgAdmin3) from OSX Sierra?

I've been having some difficulty getting up and running with PostgreSQL. Having uninstalled PostgreSQL with brew uninstall postgresql and uninstalled/removed Postgres.app I re-installed Postgresql.app....
2
votes
2answers
6k views

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

How to execute multiple statement in PgAdmin 4 like we do in Sql Server/Oracle (press F5)? select * from employees; select * from department; As much I worked with PgAdmin, it allows us to execute ...
4
votes
0answers
357 views

Postgres pgAdmin4 and table maintenance fails

I just loaded Postgres 9.6 for a dev db and using pgAdmin4 I cannot run any table maintenance at all. I added the path in the binary and it continues to fail. Please help as I have no idea how to ...
2
votes
3answers
6k views

On pgAdmin 4, how to basically copy the content of one or two cells?

I decided to go on pgAdmin 4 instead of the 3 (I'm on Windows 7). It seems that this software if somehow still in a alpha state... I would like to only get the content of one cell. So I select this ...
0
votes
1answer
561 views

PostgreSQL / pgAdminIII: is it possible to send command line commands via the UI

Using PostgreSQL / pgAdminIII, is it possible to send command line commands to PostgreSQL via the UI? Put another way: how can I access the command line via the pgAdminIII? As I am coming up to ...
7
votes
0answers
881 views

pgAdmin and PostgreSQL compatibility matrix [closed]

Has anyone ever put together a version compatibility matrix for pgAdmin versions and PostgreSQL versions? https://www.pgadmin.org/download/windows.php https://www.postgresql.org/download/windows/
0
votes
0answers
442 views

change PostgreSQL data directory

I installed postgres 9.5 quite a while ago, and since a few months ago have upgraded to 9.6 and used that. Recently I shut down my computer and restarted postgres, but when I connect to the 9.6 ...
4
votes
2answers
6k views

Stop restoring backup in pgAdmin

I am currently restoring a database and I tried to restore the database three times. The third time I succeeded but unfortunately it seems that the other two attempts at restoring the database are ...
0
votes
0answers
77 views

PostgreSQL reverting to old instance in pgAdmin4

Something very strange has happened in pgAdmin. I have been connecting to the server at port 5432 as user: postgres host: localhost for the last month. I have been using a password that I specified ...
5
votes
2answers
276 views

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

I have a series of update statements that follow a general pattern: one update aggregates values from another table (or sometimes multiple tables), the next update produces a rank based on the ...
0
votes
2answers
3k views

SQL command to clean job queue in pgAdmin 4

I have a Postgres 9.6 installation on a developer pc and a restore seems to have failed. Even after reinstalling (remove Postgres and PgAdmin completely, incl. database and installed new version) the ...