Questions tagged [pgadmin]
pgAdmin is a graphical administration and development tool for PostgreSQL.
195
questions
0
votes
0answers
4 views
Auto-complete in pgAdmin: how to get it to automatically appear?
It looks like
auto-complete is only activated after hitting ctrl + space https://www.pgadmin.org/docs/pgadmin4/4.12/keyboard_shortcuts.html
This is unexpected to me: not quite as "auto" as I would ...
0
votes
0answers
24 views
Simple “SELECT” query taking too long
I'm trying to run a SELECT query on our postgreSQL database using pgadmin3. It looks like this:
SELECT
tstamp AS "time"
dvalue AS "Weight"
FROM tablename
WHERE
tstamp BETWEEN 'time1' ...
1
vote
1answer
34 views
pgAgent service for PostgreSQL does not run
OS: Windows 10
PostgreSQL 11.4
I Installed PgAgent with Stackbuilder setup.
In Windows services; PostgreServer service is running. However, the pgAgent service is stopped. When I try to start ...
0
votes
0answers
7 views
Where can I find “pgadmin_histoqueries.xml” equivalent for pgAdmin 4 on Mac?
I am dealing with a frustrating issue that is described in this question. The accepted answer gives the solution of deleting a file that was corrupted, but I can't find the file on Mac. I suspect that ...
-1
votes
1answer
21 views
DBD::Pg::st execute failed: ERROR: canceling statement due to user request
I am using postgresql with pgadmin, I am getting following error
DBD::Pg::st execute failed: ERROR: canceling statement due to user request
CONTEXT: SQL statement "TRUNCATE mystats_na_apple....
0
votes
1answer
21 views
pgadmin: can't insert jsonb[] values with strings
I have jsonb[] column and it allows me to insert some nested arrays, but only with number values like {{1,2,3}, {4,5,6}, {7,8,9}}. I'm not talking about inserting some nested objects like {{"one": "...
0
votes
0answers
29 views
PANIC HELP Locked out of Postgres Databases and unable to find pg_hba.conf
I am using PgAdmin 4 to access a number of local databases created and hosted on postgresql 11. In a recent update, I set a global password for my databases, but forgot to set passwords for my user ...
0
votes
1answer
21 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
83 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
22 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
27 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
228 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
66 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
217 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
531 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
69 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
208 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
94 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
45 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
62 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
1k 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
828 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
636 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
11k 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" ...
1
vote
2answers
55 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
77 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
289 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
217 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?
27
votes
3answers
14k 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
5k 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
13k 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
65 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
267 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
326 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
413 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
538 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
265 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
289 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
165 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 ...
4
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
602 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 ...
