Questions tagged [pgadmin]
pgAdmin is a graphical administration and development tool for PostgreSQL.
241
questions
0
votes
0
answers
23
views
postgres without installation on Windows- Fatal error: The pgAdmin 4 server could not be contacted
Trying to run pgAdmin after setting up postgres without installation like described [here][1]
[1]: https://stackoverflow.com/a/26441939/15307393 I am getting the fatal error The pgAdmin 4 server could ...
- 121
0
votes
0
answers
41
views
pgAdmin portable without installation
Is there a possibility to run pgAdmin on Windows without any installation e.g. on a USB-drive?
0
votes
0
answers
12
views
Can I have two Query Editor panels in pgAdmin?
Can I have two different Query Editor panels in PGAdmin, side by side?
If not, is there another way of avoiding the pain point that's making me want two panels? That is:
When I'm building up a complex ...
- 165
0
votes
1
answer
79
views
Why do I see the timezone offset displayed in PgAdmin, for a timestamp with timezone
I'm using PgAdmin 4 v6, and for some timestamp data with data type of timestamp with time zone, I'm seeing it in PgAdmin like this:
2022-03-06 16:11:33+04
Why is the +04 being displayed?
I've looked ...
- 245
1
vote
0
answers
18
views
How to close connection after doing a "View/Edit" of a table
In pgAdmin 4, after I right-click on a table and choose "View/Edit data", I cannot figure out how to close that new connection. If I try to "Delete/Drop" the database, it says:
...
- 111
0
votes
0
answers
35
views
How do I adjust the table link endpoint in PgAdmin's ERD tool after autogenerating it from an existing database?
I can move the lines themselves around, but I can't move the endpoints, which cause the lines to overlap. The only way to understand which relationship is being referenced is by hovering over the ...
1
vote
0
answers
40
views
How do I copy a table from one database to another? Dump files come out empty
I am trying to "dump" a table to a file, copy that file to a different host and restore the table on a database.
My (first) problem is that I cannot dump the table data.
I use this command:
...
- 113
0
votes
0
answers
27
views
Problem with column being forced as primary-key
I am new to postgresql and having some problem when creating a table using pgadmin gui. I define a column named id as integer primary-key and another column named idchat as integer not null. But, ...
0
votes
2
answers
500
views
Is it possible to open an SQLite database inside pgadmin?
I was trying to find a way of opening SQLite databases inside pgadmin and I found this StackOverflow question where one solution points to importing the SQLite database inside PostgreSQL, and the ...
- 103
5
votes
1
answer
2k
views
What does it mean when a session is highlighted in red in the PgAdmin dashboard?
I've noticed sessions being highlighted in red recently though this never occurred in the past which leads me to believe it is a new feature. It appears to only occur on hanging queries. I looked ...
- 51
0
votes
0
answers
112
views
pgAdmin4 Doesn't Start After PostgreSQL Config
I tweaked the hba_conf file to use username and password authentication rather than ident on local and ipv4 local connections and then I noticed that pgAdmin doesn't start up at all. I'm not sure if I ...
2
votes
2
answers
5k
views
how to fix "your account is locked. please contact admin" issue in postgresql when login
I'm new to PostgreSQL.I'm using postgreSQL locally. I used it last time without any issues. Now, when I try login with my login credentials it shows the account is locked message all the time.
gowtham6672
2
votes
1
answer
43
views
In PgAdmin, what does `[...]` refer to in a result set?
Sometimes my query results include a cell containing the pattern [...]. When I export such results, they render as a blank string. However, when I try to filter on them with where column_b = '', there'...
- 123
2
votes
0
answers
61
views
pgAdmin 4 - Can't do anything after connection lost
I'm using pgAdmin 4.5 on Windows 10.
When I connect to a database, things going well. Then after some idle time, pgAdmin says "The connection is lost", then refuse to do anything, including ...
1
vote
0
answers
39
views
PSQL 9.6 - OR query is much slower on joined table
We have a production POSTGRES 9.6 db with about 100M records (LOYALTY) and new table (has just 4 data as of now) "INFO"
Full index name on table loyalty
indexname "loyalty_activated_at&...
- 111
1
vote
0
answers
691
views
How do I run pgadmin in a web browser by default?
I'm running pgadmin 5.4 on macOS Big Sur. When I open the application, pgadmin launches in Desktop Mode, as a standalone app.
My goal is to force pgadmin to run within a browser instead, but I'm ...
- 111
0
votes
0
answers
136
views
Obtain INSERT statements as a query result
Using pgAdmin on my local machine, I am able to view table data and also export the INSERT statements for the table using "backup" button (Plain format, Use column inserts, Use Insert ...
0
votes
1
answer
117
views
Why does querying a PostgreSQL database have an overhead of a few dozens of milliseconds?
Everything is in the same place, same local computer.
Whenever my Go application as well as pgAdmin 4 queries the PostgreSQL database, it takes at least a few dozens of milliseconds, however short the ...
- 101
2
votes
1
answer
1k
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 ...
- 123
0
votes
1
answer
115
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 ...
- 1
0
votes
0
answers
88
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?
...
- 127
1
vote
1
answer
7k
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 ...
- 113
0
votes
0
answers
272
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
1
answer
135
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 ...
- 157
2
votes
0
answers
140
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 ...
Ale
0
votes
1
answer
1k
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 ...
- 101
1
vote
0
answers
430
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 ...
- 111
1
vote
1
answer
130
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 ...
- 133
0
votes
1
answer
63
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
406
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
177
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 ...
- 121
1
vote
1
answer
3k
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
1
answer
9k
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 ...
- 31
0
votes
1
answer
94
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
0
answers
47
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
1
vote
1
answer
146
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 ...
user211340
1
vote
0
answers
364
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 ...
- 111
0
votes
2
answers
383
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 ...
- 133
0
votes
2
answers
3k
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 ...
- 111
1
vote
0
answers
636
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:
...
- 234
2
votes
0
answers
801
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
...
- 121
0
votes
2
answers
898
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 ...
- 216
0
votes
1
answer
935
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 ...
- 139
1
vote
0
answers
196
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 ...
- 121
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 ...
- 121
0
votes
2
answers
426
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
6k
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 ...
- 8,996
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 ...
- 165
6
votes
1
answer
10k
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 ...
- 165
7
votes
5
answers
7k
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 ...