Questions tagged [pgadmin]
pgAdmin is a graphical administration and development tool for PostgreSQL.
203
questions
0
votes
0answers
17 views
pgAdmin 4 does not work [closed]
I have installed the PostgreSQL and PostGIS and have been working well. But today when I open the Query Tool in my pgAdmin 4 the Loading button is not stopping.
I cannot access to Query Tool.
0
votes
0answers
16 views
PgAdmin 'Query tool' gets stuck in “Loading…”
Not much more to say really apart from what's in the title. I have been using PostgreSQL + PgAdmin on this one machine for some time now without much of a problem, and then last week it stopped ...
0
votes
0answers
20 views
Configuring Apache with WSGI PGAdmin applicaton
I am using Apache 2.4 and I have PGAdmin service running.
PgAdmin is listentning on 5050 port, so I can connect with it using http://127.0.0.1:5050/ or http://my-ip-address:5050/
BUT I'd like to use ...
0
votes
2answers
48 views
How to automate the detection of the column type of a csv file for a table creation script?
I am new to pgAdmin and Azure database. I have a huge csv file with around 220 columns and I want to create a table out of it in pgAdmin4 to push it to Azure.
However I don't know how to detect ...
0
votes
2answers
118 views
Edit pg_hba.conf file using pgAdmin 4
This other Question has Answers about viewing and editing settings in postgresql.conf file using pgAdmin 4. But those Answers did not mention editing the pg_hba.conf file used for authentication of ...
0
votes
1answer
148 views
pgAdmin IV and PostgreSQL 12.0: ERROR: schema “public” already exists
I have a database backup from pgAdmin III with PostgreSQL 12.0 (Ubuntu 12.0-2.pgdg16.04+1) on Ubuntu 16.04 LTS.
I would like to restore this database on my pgAdmin IV with PostgreSQL 12.0 on Docker ...
3
votes
1answer
1k views
PostgreSQL 12: column proisagg does not exist [duplicate]
I created a PostGIS database using the following images here (i.e. 9.3-2.1, 11.0-2.5 and 12.0 tags), however I'm getting the following errors when I try to open the 'public' schema:
An error has ...
2
votes
2answers
345 views
What is the last version of postgres with pgadmin 3?
For some reason I cant get used to the pgadmin 4 in web version. I found it very slow. For thing I want do fast I rather have pgadmin 3 even if that mean work with previous version of postgres.
So ...
0
votes
0answers
68 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 ...
-1
votes
1answer
68 views
Simple “SELECT” query taking too long
I'm trying to run a SELECT query on our PostgreSQL database using pgAdmin 3. It looks like this:
SELECT
tstamp AS "time"
dvalue AS "Weight"
FROM tablename
WHERE
tstamp BETWEEN 'time1' ...
1
vote
1answer
761 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
38 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
182 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
69 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
39 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
33 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
261 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
79 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
54 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
1answer
783 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
109 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
419 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
1k 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
113 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
513 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
177 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
59 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
228 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 ...
2
votes
0answers
2k 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
31 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
1answer
1k 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
842 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
16k 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
72 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
81 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
384 views
How to use postgresql service file in pgadmin4 [closed]
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
255 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
19k 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 ...
3
votes
1answer
6k 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 ...
-1
votes
2answers
6k 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
19k 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
67 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
313 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
2k 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.
...
1
vote
1answer
532 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
485 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
583 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
275 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 ...
