Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Backup and Restore option not available in pgAdmin III

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?

like image 369
Pradnya Avatar asked Jan 20 '15 12:01

Pradnya


People also ask

How do I backup and restore a PostgreSQL database?

To back up, a PostgreSQL database, start by logging into your database server, then switch to the Postgres user account, and run pg_dump as follows (replace tecmintdb with the name of the database you want to backup). By default, the output format is a plain-text SQL script file.


2 Answers

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.

like image 78
Ledazinha Avatar answered Oct 05 '22 17:10

Ledazinha


There is no need for reinstall, just open File->Options->Binary paths and add set "PG bin path" to path where pg_dump/pg_restore is located. pg_dump/pg_restore paths

like image 38
Ramunas Avatar answered Oct 05 '22 19:10

Ramunas