Questions tagged [pgadmin]
pgAdmin is a graphical administration and development tool for PostgreSQL.
188
questions
0
votes
1answer
17 views
Query returns results on pgAdmin running on remote client but not directly through psql on db server
When I query my database using a role in pgAdmin on a remote client, I get the results of the query. However if I run the same query directly on the db server with the same role , I don't see the ...
0
votes
1answer
35 views
Moving a large table from Localhost to remote server
Postgres 11, Windows 10, pgAdmin 4
I have a large post-gis enabled table (29million rows, 20GB + a 5GB spatial index) stored on my local machine (localhost).
I want to move this table to an AWS ...
2
votes
0answers
17 views
Query plan (JSON format) in pgAdmin not showing completely [duplicate]
I would like to use the tool Postgres Explain Viewer (PEV). For it I need to paste the execution plan in json format. If I try to get the execution plan in pgAdmin with this query:
EXPLAIN (ANALYZE, ...
0
votes
0answers
18 views
How to pick one particular table from different databases to single database [duplicate]
I am working with pgadmin and i would like to pick one particular named table from different databases into single single database and to be merged into single table.
1
vote
0answers
14 views
How to set the max characters per column field to specify the maximum length of data displayed in a single column in pgAdmin 4
In my table I have a column of type "json". This json data is up to 10MB big. It takes a lot of time to render such an amount of data in PgAdmin 4. Even if my table consists just of one row the ...
0
votes
0answers
100 views
Open pgAdmin4 server on a Mac
I had pgAdmin4-3.6 installed on my Mac. Worked as it should. And there was created a shortcut at installation to open the pgAdmin server.
Installing version pgAdmin4-4.6 there was no shortcut ...
0
votes
1answer
36 views
pgAdmin4 version 3.1 how to update to the last version
We use the pgAdmin4 version 3.1 on Red Hat connecting to a server PostgresQL 9.6.
In the log of the server, I notice some errors generated by the pga4dash :
ERROR: column "waiting" does not exist ...
0
votes
0answers
135 views
Fail to load pg_hba.conf
I can't connect to server. Using psql -h 127.0.0.1 -U postgres -d mydb and pgAdmin, in both case:
psql: could not connect to server: Connection refused
Is the server running on host "127.0.0.1" ...
1
vote
1answer
21 views
Formatting query to respond to past column values
I'm writing a query that follows the process of forms being processed through various SQL functions - they receive status numbers as they go through the process. I want to pull forms that are in a ...
1
vote
1answer
288 views
Postgres support for UUID [closed]
My understanding is that Postgres supports UUID data type out-of-the-box. I'm running Postgres on Amazon RDS with Engine version 10.6 and am scratching my head as to why the following commands are not ...
0
votes
0answers
42 views
PgAdmin3 connection to database failed with no error messages
I have a local postgres database with PgAdmin3 LTS by BigSQL on my laptop that until today I could access without any problems. When I tried to access it today by typing the password I get only a "...
1
vote
1answer
116 views
pgAdmin 4 v4 does not prompt to save on page refresh
(I can't seem to find this issue anywhere else despite being a seemingly common issue)
Typically when I'm using the Query Editor I press F5 to run my query. With pgAdmin being a browser application, ...
1
vote
1answer
67 views
Postgres 9.6 (pgAdmin 4) - How to query daily statistics
Is there a way I can query through pgAdmin in a way I will get statistics for daily query usage?
I need to find what queries are run against my api as I get huge network traffic. I'm looking for a ...
0
votes
1answer
34 views
adding pgadmin3 to windows start menu
I have installed postgres (different versions actually) as well as pgadmin3 on windows using the package manager:
https://www.openscg.com/bigsql/package-manager/
https://www.openscg.com/bigsql/docs/...
1
vote
1answer
35 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
701 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 ...
1
vote
1answer
27 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 ...
2
votes
0answers
659 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
556 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
10k 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
44 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
71 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
243 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
197 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?
25
votes
3answers
12k 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 ...
2
votes
1answer
4k 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
4k 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:...
2
votes
3answers
11k 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
63 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
233 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
1k 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
248 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
387 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
523 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
258 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
269 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
2k 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
1k 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
151 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
3k 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 ...
3
votes
1answer
2k 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
4answers
2k 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
553 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
288 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 ...
4
votes
1answer
9k 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 ...
2
votes
1answer
926 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....
3
votes
1answer
8k 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
437 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
611 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
5k 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 ...
