Questions tagged [pgadmin]
pgAdmin is a graphical administration and development tool for PostgreSQL.
266
questions
0
votes
0
answers
133
views
How to change the Postgres hostname in pgadmin 4? [duplicate]
By default, the database hostname is localhost after the Postgres has been installed.
Can the hostname be changed to something else like localhost\\abc?
If yes, how can I do it in Windows/pgadmin?
...
1
vote
1
answer
10k
views
Restoring a backup gives "Failed exit code 1"
I'm migrating from Heroku's Postgres to AWS RDS. I've generated a pg_backup.dump file from Heroku, installed Postgres on my local machine, launched PGAdmin, configure remote AWS server, and used the ...
0
votes
1
answer
617
views
Is there a native(none-web) GUI client of pgadmin4?
I don't like web-based GUI, so I only installed the pgadmin4-desktop package for my Kubuntu 20.04, instead of pgadmin4-web and pgadmin4.
According to the offical web page of pgAdmin4,
A desktop ...
2
votes
0
answers
273
views
How can I change the password for pgadmin in Windows?
I want to know how I can change the password of pgAdmin, the same one that is created when it is installed in Windows
The point is that I have not forgotten, but for personal reasons I want to change ...
0
votes
1
answer
6k
views
remove postgres server from local machine
I know this is a real beginner question. But nevertheless I'm really confused:/
I wanted to have a clean installation of postgres on my ubuntu laptop. So I tried to delete everything related to ...
3
votes
0
answers
1k
views
pgAdmin 4, force "The application has lost the database connection:"
Whenever I put my computer in sleep mode pgAdmin 4 loses the connection to the remote Postgresql database (and that's fine). When I start up the computer again I have two options. Either restart ...
1
vote
1
answer
1k
views
Connections remain active even after terminating the session in Postgres
Yesterday, I added the pldbgapi extension in my Postgres DB to debug a function. I was using PgAdmin for debugging the same. But today, when I tried invoking a simple query, it was taking a lot of ...
0
votes
1
answer
115
views
Why pgadmin dont enter in admin panel?
I install postgresql-12.4 on my win pc. When i'm trying to enter into admin panel (pgadmin) i cathcing message:
could not connect to server: Connection refused (0x0000274D/10061) Is the server running ...
0
votes
1
answer
1k
views
How to validate negative values in query
Hi I am using postgresql in my project. I want to make a validation that if query returns negative then i want to change output to null.
(to_char (NULLIF(coalesce(0::numeric,0) -
(coalesce(26776.94::...
1
vote
0
answers
339
views
Can I pass an SSH Tunnel credentials into a postgresql PgAdmin Connection string?
I am following this guide for replication across postgresql tables. It is fairly straight forward and so far I have no issues. However, this string is will be a hurdle:
CREATE SUBSCRIPTION ...
5
votes
1
answer
16k
views
How to take backup of schema postgresql?
Hi I am currently using postgresql and deleting some of the tables for testing purpose and I want to take backup of schema. can any one let me know how to do that ?
4
votes
1
answer
15k
views
"ERROR: column rel.relhasoids does not exist" with PostgreSQL 12 and PgAdmin 4.3
I get the following error when trying to select rows from a table:
ERROR: column rel.relhasoids does not exist
LINE 1: SELECT rel.relhasoids AS has_oids
Configuration is:
Linux RHL8
NAME="Red ...
0
votes
1
answer
913
views
Unable to create view with temp table
Hi I am working on one project and want to create a view. I am using temp table in my query. can any one let me know how we can create such view ?
Following is my query, I tried using WITH..AS , but ...
2
votes
1
answer
354
views
Is the official term "template database" or "maintenance database"?
pgAdmin has a field for the "maintenance database". The PostgreSQL manual talks about template databases.
What is the correct term? Why are they not consistent? This is even more confusing ...
1
vote
0
answers
950
views
pgAdmin 4 restore ignores "Clean before restore"
I am using pgadmin v4.22 to backup and restore a database. This works fine the first time, but when I want to restore it again to a backup with deleting the old data, pgAdmin seems to ignore the Clean ...
0
votes
2
answers
873
views
A Remote GUI for PostgreSQL [closed]
I've installed PostgreSQL 12 server onto an Ubuntu 20.04 server, but I want to access it using a GUI from my Kubuntu 20.04 laptop. I'd be interested to know any options for GUI administration.
I have ...
1
vote
3
answers
6k
views
How to import multiple CSV files to a postgres table using pgadmin or other method?
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
0
answers
1k
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:
...
2
votes
0
answers
2k
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
2
answers
2k
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
1
answer
3k
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 ...
1
vote
0
answers
391
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 ...
2
votes
1
answer
3k
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 ...
1
vote
2
answers
1k
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
2
answers
13k
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
1
answer
3k
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 ...
6
votes
1
answer
12k
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 ...
9
votes
6
answers
10k
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 ...
7
votes
1
answer
6k
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
1
answer
2k
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' ...
2
votes
1
answer
11k
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 ...
-1
votes
1
answer
7k
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....
1
vote
2
answers
2k
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
0
answers
307
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 ...
2
votes
1
answer
662
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 ...
1
vote
1
answer
2k
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
0
answers
268
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
0
answers
337
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
1
answer
5k
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
0
answers
3k
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
1
answer
24
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 ...
2
votes
1
answer
8k
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
1
answer
2k
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
1
answer
1k
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
1
answer
211
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/...
2
votes
1
answer
2k
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
0
answers
5k
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
1
answer
211
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 ...
5
votes
2
answers
9k
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 ...
4
votes
1
answer
57k
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" ...