Backup and Restore option not available in pgAdmin III

database postgresql backup pgadmin pg-restore
Pradnya picture Pradnya · Jan 20, 2015 · Viewed 14.9k times · Source

I have to take backup of my database but when I right click DB and then backup The button for backup is disabled. Similarly in existing database ,not able to restore because the Restore button too disabled. I was working fine till the time I created a new database.

How do they get enabled?

Answer

Ledazinha picture Ledazinha · Feb 16, 2016

I had the same problem in ubuntu 14.04. It was necessary to install both postgresql-client-common (which contains pg_dump and pg_restore) and postgresql-client packages.

Related questions

Postgres: clear entire database before re-creating / re-populating from bash script

I'm writing a shell script (will become a cronjob) that will: 1: dump my production database 2: import the dump into my development database Between step 1 and 2, I need to clear the development database (drop all tables?). How is this best accomplished …

Read More
Backup/Restore a dockerized PostgreSQL database

I'm trying to backup/restore a PostgreSQL database as is explained on the Docker website, but the data is not restored. The volumes used by the database image are: VOLUME ["/etc/postgresql", "/var/log/postgresql", "/var/lib/postgresql"] and the …

Read More
postgresql where does the output of pg_dump go

I am trying to backup a db of postgresql and I want to use pg_dump command. I tried : psql -U postgres postgres-# pg_dump test > backup.sql But I don't know where the output file goes. Any help …

Read More