Questions tagged [pgadmin]
pgAdmin is a graphical administration and development tool for PostgreSQL.
1
vote
1answer
15 views
Export each row of a table into a separate text file
I have a table in my database that contains data with three columns: id, name, and notes. The notes column contains unstructured text data that I want exported for each row as its own text file. This ...
1
vote
0answers
15 views
Switching users in PgAdmin
I'm looking for a way to enable switching between users in pgAdmin 4. I'm aware of the possibilty to change user from the properties-dialog before connecting. However this isn't useful when I'm ...
0
votes
0answers
10 views
Convert multiple GML files to postgres tables using ogr2ogr
I have a folder with 150 .gml files I need to upload to my postgis/postgres database. After the first gml is uploaded, the rest will be appended to it to form a single table. However I don't know how ...
0
votes
0answers
508 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
25 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 ...
1
vote
0answers
109 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
219 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
2k 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
33 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
105 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
97 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
153 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
67 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 ...
13
votes
3answers
6k 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
36 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
2k 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
5k 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
55 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
148 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
882 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
108 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
276 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
414 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
237 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
148 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
1k 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
829 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
94 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
2k 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
1k 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
785 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
382 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
184 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
6k 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
628 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
4k 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
355 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
522 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
3k 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
14k 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
4k 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
7k 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
383 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
7k 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
649 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
1k 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
482 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
7k 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 ...
