Questions tagged [pgadmin]
pgAdmin is a graphical administration and development tool for PostgreSQL.
208
questions
0
votes
0answers
16 views
How to import multiple CSV files to a postgres table using pgadmin?
I'm looking to import a folder of over 100+ csv files into one table on PostgreSQL using pgadmin. I have the following script but is there a way to change the file path to all csvs?
COPY schema.table ...
1
vote
0answers
32 views
Is it possible to change the browser that pgadmin4 uses?
I have Debian 10, pgadmin4, and KDE. When I open pgadmin4, it opens with Firefox. I have several other browsers installed. If I try to paste the link in any other browser, I get this error message:
...
1
vote
0answers
20 views
PgAdmin: backup and restore schemas using the GUI
I know how to backup and restore one or more schema(s) from a PostgreSQL database using psql:
Go to the folder that contains the executables of PostgreSQL:
cd C:\Program Files\PostgreSQL\11\bin
...
0
votes
0answers
15 views
What is pgAdmin doing in the background while the browser tab is not open?
I am using pgAdmin in the browser and everytime I open the tab, the rates are dropping in the dashboard. I have no idea why this is and what pgAdmin is doing in the background while the tab is not ...
0
votes
2answers
43 views
Connect to a local PostgreSQL server using peer auth with pgAdmin
Context
I have a PostgreSQL server running on a remote machine, but I'm connected locally through VPN.
Its pg_hba.conf file is accepting peer auth for local connections;
local all ...
0
votes
0answers
8 views
Postgres PGADMIN4 DB Restriction at user level
I have seen DB Restriction option to hide databases in pgadmin4 which user haven't access.
My requirement is, to give access to only few schemas in a single database for a user. The user should be ...
0
votes
1answer
29 views
How to create a database or role in pgAdmin4?
I want to create a database in pgAdmin4 but a corresponding item in the menu is grayed out.
I also tried to create a role, thinking that I might be lacking permissions to create database in first ...
0
votes
0answers
26 views
Postgres setup for multiple projects
I have a Postgres db server setup on my raspberry pi. With this I am working on two distinct projects:
Project1
Project2
For these projects I have different users and the users of each should not ...
0
votes
0answers
8 views
Is there some parameter/flag I can use to make pgAdmin 4 update silently without the GUI?
Every single time pgAdmin 4 has an update, I have made it so that it grabs the latest installer (this is on Windows) and puts it on my desktop, then notifies me. I then have to manually run this GUI ...
2
votes
1answer
288 views
How do I view data in pgAdmin 4? [closed]
Similar to How to view data in pgAdmin III, how do I view data in pgAdmin 4? Like the other question, I can't believe they (still) make it this hard.
I have created a table and bunch of records using ...
1
vote
1answer
327 views
Navicat Premium doesn't show/list tables in postgres database schema
I have a local instance of postgres in my Windows machine, when I explore the databases and schemas in PgAdmin4 I can see every table and make queries and etc.
But when I connect to this same ...
0
votes
2answers
59 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
508 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
543 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
3k 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
4answers
817 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 ...
1
vote
0answers
192 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
76 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
2k 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
54 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
359 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
2answers
207 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
47 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
43 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
411 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
117 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, ...
1
vote
0answers
79 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
1k 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
138 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
655 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
2k 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 ...
1
vote
1answer
777 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
271 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
64 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
306 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
35 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 ...
3
votes
1answer
2k 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
1answer
19k 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
113 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
83 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
458 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 ...
2
votes
0answers
297 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?
31
votes
3answers
24k 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 ...
4
votes
1answer
7k 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
8k 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
25k 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
68 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
345 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,...
