Questions tagged [pgadmin]

pgAdmin is a graphical administration and development tool for PostgreSQL.

Filter by
Sorted by
Tagged with
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,...

1
2 3 4 5