Re: BUG #14410: Restoring data not successful

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: jordan(dot)woodhead(at)bjss(dot)com
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14410: Restoring data not successful
Date: 2016-11-03 23:26:39
Message-ID: CAB7nPqQdze_vyH6wAbx5aZY7quJBaO+KtCt-_CPdVfAQ-+x6Xw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Nov 3, 2016 at 8:16 PM, <jordan(dot)woodhead(at)bjss(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jamie Koceniak 2016-11-04 00:05:42 Re: BUG #14411: Issue with using OFFSET
Previous Message Michael Paquier 2016-11-03 23:24:39 Re: Problems with "pg.dropped" column after upgrade 9.5 to 9.6