Re: Issues restoring tables

2016-11-28 16:53 GMT+01:00 Jordan Woodhead <Jordan(dot)Woodhead(at)bjss(dot)com>:

> 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.
>
>
>

Looks like the kind of messages you'd get if you restore on an 9.3 Postgres
with a 9.5 pg_restore. Are you still connecting to your 9.3 database?

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com