CODEWITHSUNDEEP
postgresqlpgadminpgadmin-4
Jordan Woodhead
Jordan Woodhead

Reputation: 11

Why is pg_restore returning successfully but not actually restoring my database? PostgreSQL 9.5

I'm trying to use PostgreSQL 9.5 with pgAdmin 4 (I would prefer to use pgAdmin 3 but I get the following message when trying to connect to my database: "Warning:

The server you are connecting to is not a version that is supported by this release of pgAdmin III.

pgAdmin III may not function as expected.

Supported server versions are 8.4 to 9.3")

So I'm forced to use pgAdmin 4. However, when I restore (like I usually do on pgAdmin III) I get a 'successful' restore but no data is actually restored into the tables.

If I click on the details of the 'successful' restore I am presented with this:

"1. pg_restore: connecting to database for restore"

How do I fix this issue?

Upvotes: 1

Views: 1988

Answers (1)

Murtuza Z
Murtuza Z

Reputation: 6017

Would you provide pgAdmin4 logs after running restore?

pgAdmin4 Log location:

Linux:

~/.pgadmin/pgAdmin4.log

~/.pgadmin/job_logs/

Windows:

%appdata%\pgAdmin\pgAdmin4.log

%appdata%\pgAdmin\job_logs\

Note: Do not close Success dialog in pgAdmin4 after restore otherwise once you acknowledge the success dialog, pgAdmin4 will delete respective job log files from "job_logs" directory & also delete "pgAdmin4.log" before running restore to trim unwanted logs.

Upvotes: 0

Related Questions