Questions tagged [pgadmin]
pgAdmin is a graphical administration and development tool for PostgreSQL.
229
questions
0
votes
0answers
18 views
Creating a new table from another make it read-only in PGadmin interface
On PostgreSQL 11, I've created a new table from another, using a subquery :
CREATE TABLE table2 AS (SELECT * FROM table1)
As a result, table2 is created, but each column is in read-only mode within ...
0
votes
1answer
22 views
Determining primary key columns in PGAdmin, if the constraint name is generated by system
I am trying to learn a new schema of a PostgreSQL database, but it's unclear from looking at pgAdmin which columns per the tables constitute the primary keys. It appears that when the tables were ...
0
votes
0answers
14 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?
...
0
votes
0answers
6 views
Typing with two carets in pgAdmin editor
While I'm working with pgAdmin Query Tool I sometimes accidentally enter the mode when two carets appear in the editor and same characters are inserted in two places of text simultaneously while I'm ...
1
vote
1answer
2k 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
0answers
56 views
Remote access problem - PostgreSQL
I'm don't know much about database management, so to enable the remote access to my postgresql db I followed some tutorials. I've updated pg_hba_conf and postgresql_conf files.
In pg_hba_conf I added ...
0
votes
0answers
20 views
Can view tables from command line but not from pgadmin
I restored a cluster from base backups. The version of postgresql is 12.4. After starting the postgresql service, and logging into the cluster (from putty), I can see the dbs, and even the tables in ...
0
votes
0answers
57 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
0answers
63 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
1answer
72 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 ...
1
vote
0answers
243 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
1answer
25 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
1answer
35 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
1answer
100 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
0answers
66 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 ...
0
votes
1answer
114 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 ?
3
votes
1answer
4k 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
1answer
36 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 ...
0
votes
0answers
22 views
Sorting postgres table by column value
I am relatively new to postgresql. Is there a way to sort a table by a column value and then save the changes permanently? (in my case the value is an integer)
1
vote
1answer
51 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
0answers
88 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
2answers
137 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 ...
0
votes
0answers
68 views
How can you see PostgreSQL procedures in Azure Data Studio?
If I use pgAdmin 4 to query PostgreSQL, I can see procedures section under materialized views. But, If I use Azure Data Studio I cannot see the procedures section. Any idea how to get to see the ...
0
votes
2answers
1k 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
0answers
309 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
0answers
127 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
26 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
291 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
43 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
233 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
0answers
81 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
1answer
2k 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
133 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
3k 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
1k 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 ...
5
votes
1answer
7k 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 ...
5
votes
5answers
4k 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
590 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
201 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
4k 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
1answer
890 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
567 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
77 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
67 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
1answer
678 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
193 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
150 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
3k 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
158 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
1k 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" ...