Thread: BUG #14410: Restoring data not successful

VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQxMApMb2dnZWQgYnk6ICAg
ICAgICAgIEpvcmRhbiBXb29kaGVhZApFbWFpbCBhZGRyZXNzOiAgICAgIGpv
cmRhbi53b29kaGVhZEBianNzLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDku
NS4wCk9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cyA3CkRlc2NyaXB0aW9u
OiAgICAgICAgCgpXaHkgaXMgcGdfcmVzdG9yZSByZXR1cm5pbmcgc3VjY2Vz
c2Z1bGx5IGJ1dCBub3QgYWN0dWFsbHkgcmVzdG9yaW5nIG15CmRhdGFiYXNl
Pw0KDQpJJ20gdHJ5aW5nIHRvIHVzZSBQb3N0Z3JlU1FMIDkuNSB3aXRoIHBn
QWRtaW4gNCAoSSB3b3VsZCBwcmVmZXIgdG8gdXNlCnBnQWRtaW4gMyBidXQg
SSBnZXQgdGhlIGZvbGxvd2luZyBtZXNzYWdlIHdoZW4gdHJ5aW5nIHRvIGNv
bm5lY3QgdG8gbXkKZGF0YWJhc2U6ICJXYXJuaW5nOg0KDQpUaGUgc2VydmVy
IHlvdSBhcmUgY29ubmVjdGluZyB0byBpcyBub3QgYSB2ZXJzaW9uIHRoYXQg
aXMgc3VwcG9ydGVkIGJ5IHRoaXMKcmVsZWFzZSBvZiBwZ0FkbWluIElJSS4N
Cg0KcGdBZG1pbiBJSUkgbWF5IG5vdCBmdW5jdGlvbiBhcyBleHBlY3RlZC4N
Cg0KU3VwcG9ydGVkIHNlcnZlciB2ZXJzaW9ucyBhcmUgOC40IHRvIDkuMyIp
DQoNClNvIEknbSBmb3JjZWQgdG8gdXNlIHBnQWRtaW4gNC4gSG93ZXZlciwg
d2hlbiBJIHJlc3RvcmUgKGxpa2UgSSB1c3VhbGx5IGRvCm9uIHBnQWRtaW4g
SUlJKSBJIGdldCBhICdzdWNjZXNzZnVsJyByZXN0b3JlIGJ1dCBubyBkYXRh
IGlzIGFjdHVhbGx5CnJlc3RvcmVkIGludG8gdGhlIHRhYmxlcy4NCg0KSWYg
SSBjbGljayBvbiB0aGUgZGV0YWlscyBvZiB0aGUgJ3N1Y2Nlc3NmdWwnIHJl
c3RvcmUgSSBhbSBwcmVzZW50ZWQgd2l0aAp0aGlzOg0KDQoiMS4gcGdfcmVz
dG9yZTogY29ubmVjdGluZyB0byBkYXRhYmFzZSBmb3IgcmVzdG9yZSIKCg==

On Thu, Nov 3, 2016 at 8:16 PM,  <jordan.woodhead@bjss.com> wrote:
> Why is pg_restore returning successfully but not actually restoring my
> database?
>
> 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"

You may want to ask directly folks in charge of pgadmin regarding what you see:
https://pgadmin.org/support/
--
Michael