2022 Developer Survey is open! Take survey.

Questions tagged [pgadmin]

pgAdmin is a graphical administration and development tool for PostgreSQL.

Filter by
Sorted by
Tagged with
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 ...
user avatar
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?
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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: ...
user avatar
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 ...
user avatar
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: ...
user avatar
  • 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, ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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.
user avatar
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'...
user avatar
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 ...
user avatar
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&...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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? ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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::...
user avatar
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 ...
user avatar
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 ?
user avatar
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 ...
user avatar
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 ...
user avatar
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)
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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: ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar

1
2 3 4 5