Обсуждение: Issues restoring tables

Поиск
Список
Период
Сортировка

Issues restoring tables

От
Jordan Woodhead
Дата:
<div class="WordSection1"><p class="MsoNormal">Hi,<p class="MsoNormal"> <p class="MsoNormal">I’m having issues
restoringtables. <p class="MsoNormal"> <p class="MsoNormal">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
thefollowing error message:<p class="MsoNormal"> <p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#242729;border:nonewindowtext
1.0pt;padding:0cm;mso-fareast-language:EN-GB"><br/> 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</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#242729;mso-fareast-language:EN-GB"> –</span><p
class="MsoNormal"> <pclass="MsoNormal">Please could you advise on what the issue is and what I need to do in order to
fixthis issue as nobody seems to know on the internet. <p class="MsoNormal"> <p class="MsoNormal">Thanks,<p
class="MsoNormal"> <pclass="MsoNormal">Jordan</div><br /><p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Arial",sans-serif">Theinformation included in this email and any files transmitted
withit may contain information that is confidential and it must not be used by, or its contents or attachments copied
ordisclosed 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
undertakenwill apply. Please carry out virus or such other checks as you consider appropriate in respect of this email.
BJSSdoes not accept responsibility for any adverse effect upon your system or data in relation to this email or any
filestransmitted with it. BJSS Limited, a company registered in England and Wales (Company Number 2777575), VAT
RegistrationNumber 613295452, Registered Office Address, First Floor, Coronet House, Queen Street, Leeds, LS1
2TW.</span>

Re: Issues restoring tables

От
Guillaume Lelarge
Дата:
2016-11-28 16:53 GMT+01:00 Jordan Woodhead <Jordan.Woodhead@bjss.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?


--