Questions tagged [pgadmin]

pgAdmin is a graphical administration and development tool for PostgreSQL.

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

1
2 3 4 5