Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [pgadmin]

pgAdmin is a graphical administration and development tool for PostgreSQL.

Current version as of 2015-02-25: pgAdmin 1.20.0
Details on the project home page.

272 questions
58
votes
2 answers

pgAdmin: What is the Maintenance DB?

pgAdmin's Register - Server dialog for adding new database connections asks for a "Maintenance database". In order to be able to connect, I set it to the database I want to connect (and also, I have the rights to connect). So, why is that field…
jgomo3
  • 714
  • 1
  • 5
  • 10
40
votes
3 answers

pgAdmin 4 version 3 fails to open a second time

I just installed pgAdmin 4 version 3.0.0 for macOS Sierra, replacing the pgAdmin that came bundled with Postgres 10.3 running locally on the same Mac. I opened the pgAdmin 4.app app icon, which caused Safari browser to come to the front with a tab…
Basil Bourque
  • 11,188
  • 20
  • 63
  • 96
39
votes
8 answers

save/export PGAdmin server list configuration settings

I have a ton of configured connections listed in the Server Groups, is there a way I can save this? not just save the passwords but the Server Group Settings
Phill Pafford
  • 1,415
  • 6
  • 19
  • 26
38
votes
3 answers

Binary path in the pgAdmin preferences

I installed PostgreSQL because I need to restore a large .backup file I received for upload to another platform (it's 38 million rows which was apparently too large for the person to export any other way). When I try to "restore" in pgAdmin 4 I get…
randodatauser
  • 381
  • 1
  • 3
  • 3
34
votes
4 answers

Retrieving all PK and FK

I have a big database that I need to extract all primary keys and foreign keys from each table. I have pgAdmin III. Is there a way to do this automatically and not go over each table manually?
Nick Ginanto
  • 1,009
  • 3
  • 10
  • 10
28
votes
1 answer

How do I restore a plain text postgres .backup file

I exported a postgres db from pgAdmin in a plain format because I wanted to search the whole db text. I then tried to restore the database back but it gives an error saying that the archive file is not valid archive file. How do I restore the db…
yankitwizzy
  • 401
  • 1
  • 5
  • 7
26
votes
2 answers

PgAdmin III - How to connect to database when password is empty?

I have installed PostgreSQL 9.1 on my PC (Win 7). I have a small Java application connecting successfully to it with login=sa and password="". The connection works. However, it is refused from PgAdmin III itself. I get: Error connecting to the…
Jérôme Verstrynge
  • 1,481
  • 5
  • 23
  • 27
25
votes
3 answers

How do I specify that a column should be auto-incremented in pgAdmin?

I have started to learn pgAdmin III to manage a PostgreSQL database. But it wasn't an easy to use application. If I create or have created a table with pgAdmin III, how can I add "auto-increment"-functionality on a column id that has type integer?
Jonas
  • 33,945
  • 27
  • 62
  • 64
24
votes
2 answers

PostgreSQL "size of temporary files"

I've imported data into a new database (about 600m rows of timestamp, integer, double). I then created some indexes and tried to alter some columns (got some out of space issues), the database is vacuumed. Now pgAdmin III tells me that the "Size of…
Ofiris
  • 811
  • 6
  • 10
  • 19
23
votes
1 answer

How to connect to an remote PostgreSQL database on Ubuntu using pgAdmin3?

I'm trying to setup a PostgreSQL database on an Ubuntu machine. I would like to be able to access it using pgAdmin3 from a remote machine. How do I setup this? I have installed the PostgreSQL database on Ubuntu using: sudo apt-get install…
Jonas
  • 33,945
  • 27
  • 62
  • 64
22
votes
3 answers

Is there a way to access temporary tables of other sessions in postgres?

I'm working with a Windows application that uses a (local) postgres Database and stores some information in a temporary table. I'd like to have a look at the temporary table, but pgadmin and dbVis tell me: ERROR: cannot access temporary tables of…
newenglander
  • 1,075
  • 5
  • 13
  • 23
21
votes
6 answers

How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8?

I was given the task to migrate a PostgreSQL 8.2.x database to another server. To do this I'm using the pgAdmin 1.12.2 (on Ubuntu 11.04 by the way) and using the Backup and Restore using the custom/compress format (.backup) and UTF8 encoding. The…
pedrosanta
  • 3,463
  • 3
  • 17
  • 7
21
votes
3 answers

Keyboard shortcut to execute statement at cursor in pgAdmin

In MySQL Workbench, one can use the keyboard shortcut Ctrl + ENTER to execute the statement at cursor (delineated with semi colons). Is there a similar shortcut in pgAdmin? For SQL queries that span on only one line, I use a voice command in Dragon…
Franck Dernoncourt
  • 2,083
  • 13
  • 34
  • 52
18
votes
1 answer

Usage of COPY FROM STDIN in postgres

I just started using Postgres and I'm trying to create a sample db to understand its functions, looking around, I found some scripts in pgfoundry.org. I understand the commands, since I previously used both Oracle and MS-SQL, but all the scripts I'm…
Eugenio Laghi
  • 283
  • 1
  • 2
  • 6
17
votes
2 answers

pgAdmin to display multiple result sets

With MS SQL Query Browser I can run multiple queries at the same time and each result set will display in it's own window. Does PostgreSQL/pgAdmin have this functionality? Plugin perhaps?
Phill Pafford
  • 1,415
  • 6
  • 19
  • 26
1
2 3
…
18 19