Unable to Restor Table Named "User"
От | Soule, Cathi (HQP) |
---|---|
Тема | Unable to Restor Table Named "User" |
Дата | |
Msg-id | 6FE8E301C4B5FB469E9FDEDACEF27D94AF596C@N1-1EXC-MBX06N2.na.msds.rhi.com обсуждение исходный текст |
Ответы |
Re: Unable to Restor Table Named "User"
Re: Unable to Restor Table Named "User" |
Список | pgadmin-support |
<div class="WordSection1"><p class="MsoNormal">Hello,<p class="MsoNormal"> <p class="MsoNormal">We are not able to restorea table using pgAdmin from object browser. We have been successful using backup / restore functions with 30 othertables. However, we are not able to restore one table named ‘user’. Here are details: Thank you!<p class="MsoNormal"> <pclass="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">-<spanstyle="font:7.0pt "Times New Roman""> </span></span>pgAdmin version 1.20.0<p class="MsoListParagraph"style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">-<span style="font:7.0pt"Times New Roman""> </span></span>Windows 7, 64-bit<p class="MsoNormal"> <p class="MsoNormal">Messagesreturned is as follows. Note that a successful restore had 2 additional msgs (pg_restore: processingdata for table "skillc" pg_restore: setting owner and privileges for TABLE DATA skillc). Defaults were used onbackup and restore. Does anyone know how to resolve? Thank you for any help! <p class="MsoPlainText"> <p class="MsoPlainText"> <pclass="MsoPlainText">MESSAGES RETURNED FROM UNSUCCESSFUL RESTORE--<p class="MsoPlainText">C:/ProgramFiles/PostgreSQL/9.4/bin\pg_restore.exe --host localhost --port<p class="MsoPlainText">5432--username "postgres" --dbname "d27qs7oej1f23" --no-password --data-only --table \"user\" --schemaxyz1 --verbose "E:\20150611 Mig32QA user4.backup"<p class="MsoPlainText">pg_restore: connecting to database for restore Process returned exit code 0. <p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"><spanstyle="font-family:"Lucida Calligraphy"">Cathi Soule</span><p class="MsoNormal"><a href="mailto:Cathi.Soule@roberthalf.com"><spanstyle="color:blue">Cathi.Soule@roberthalf.com</span></a><p class="MsoNormal"> </div>
В списке pgadmin-support по дате отправления: