CODEWITHSUNDEEP
databasepostgresqlbackuppgadminpg-restore
Pradnya
Pradnya

Reputation: 669

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?

Upvotes: 17

Views: 19708

Answers (9)

Danish Analyst
Danish Analyst

Reputation: 55

I was facing problem in restoring my database from backup, so I followed some steps:

  1. Go to c:\ drive and find this path "C:\Program Files\PostgreSQL\13\bin"
  2. Copy all the files from there then
  3. past all the copied files to the given folder "C:\Program Files\PostgreSQL\13\pgAdmin 4\runtime"

Your problem will definitely be solved.

You can go and check my video Where I showed step by step problem.

[link] (https://youtu.be/GS3Dg0TfyFI)

Upvotes: 1

Michael Krebs
Michael Krebs

Reputation: 11

I have checked in the pgadmin4 sql:

SELECT * FROM pg_available_extensions;

and got the current installed 2.1 which is not correct. You need to check on the db command line, the same query did result that the adminpack is NOT installed.

Solution: Logon to the DB on comand line and write

CREATE EXTENSION adminpack;

Upvotes: 0

sh6210
sh6210

Reputation: 4530

in my case i'm on windows,

if python isn't installed, install it.

restart, and you're done.

Upvotes: 0

rsc
rsc

Reputation: 4434

Problem could be caused by a fact that you simply do not have pg_dump and pg_restore tools installed (or they are not visible for pgadmin).

This had happen to me when installing pgadmin3 on CentOS 7 via PostgreSQL yum repository. To resolve this I had to install package with those tools - in my case postgresql94 (PostgreSQL client programs and libraries).

On other distros you will need to find which package should be installed. AFAIK this issue is not present in Windows environment, pgadmin installer probably have all needed dependencies.

Upvotes: 2

Ramunas
Ramunas

Reputation: 1175

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

Upvotes: 10

Zanon
Zanon

Reputation: 30710

I had this issue (restore button disabled) and the problem was a corrupted dump.

So, I've created a new dump and tried again. After selecting the new file, the button became available.

Upvotes: 0

Mario García
Mario García

Reputation: 31

Here is a solution:

$ yum install postgresql-contrib

Upvotes: 3

Erik_van_der_Arend
Erik_van_der_Arend

Reputation: 180

Just reinstall your PGAdmin3.

We had the same problem on a Mac and after reinstallation, the right click menu showed more options like "Restore" and "Backup".

Upvotes: 0

Ledazinha
Ledazinha

Reputation: 319

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.

Upvotes: 11

Related Questions