Issues restoring tables

From: Jordan Woodhead <Jordan(dot)Woodhead(at)bjss(dot)com>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Issues restoring tables
Date: 2016-11-28 15:53:06
Message-ID: HE1PR0401MB2281271407D73E2740044CE1948A0@HE1PR0401MB2281.eurprd04.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

I'm having issues restoring tables.

I was able to do this just fine on PGAdmin 3 using Postgres 9.3. I've upgraded to Postgres 9.5 and I want to be able to restore the tables just like I did in PGAdmin 3 but I get the following error message:

20161121135210265000,pg_restore: connecting to database for restore 20161121135210265000,pg_restore: [archiver (db)] Error while INITIALIZING: 20161121135210265000,pg_restore: [archiver (db)] could not execute query: ERROR: unrecognized configuration parameter "row_security" 20161121135210265000, Command was: SET row_security = off; 20161121135210265000, 20161121135210265000,WARNING: errors ignored on restore: 1 -

Please could you advise on what the issue is and what I need to do in order to fix this issue as nobody seems to know on the internet.

Thanks,

Jordan

The information included in this email and any files transmitted with it may contain information that is confidential and it must not be used by, or its contents or attachments copied or disclosed to, persons other than the intended addressee. If you have received this email in error, please notify BJSS. In the absence of written agreement to the contrary BJSS' relevant standard terms of contract for any work to be undertaken will apply. Please carry out virus or such other checks as you consider appropriate in respect of this email. BJSS does not accept responsibility for any adverse effect upon your system or data in relation to this email or any files transmitted with it. BJSS Limited, a company registered in England and Wales (Company Number 2777575), VAT Registration Number 613295452, Registered Office Address, First Floor, Coronet House, Queen Street, Leeds, LS1 2TW.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Devrim Gündüz 2016-11-29 00:07:18 Re: PgAdmin4 STILL not usable when installed from RPMs on Fedora linux
Previous Message Ashesh Vashi 2016-11-28 07:53:36 Re: Backup database runs forever