Re: Unable to Restor Table Named "User"

Поиск
Список
Период
Сортировка
От Ashesh Vashi
Тема Re: Unable to Restor Table Named "User"
Дата
Msg-id CAG7mmozE2nfKnb1jDLhAbVfE_kXsw+kCS0kwYC3R8ugGc10YDA@mail.gmail.com
обсуждение исходный текст
Ответ на Unable to Restor Table Named "User"  ("Soule, Cathi (HQP)" <cathi.soule@roberthalf.com>)
Ответы Re: Unable to Restor Table Named "User"
Список pgadmin-support
Дерево обсуждения
Try this command on the command-prompt:

"C:\Program Files\PostgreSQL\9.4\bin\pg_restore.exe" --host localhost --port 5432 --username "postgres" --dbname "d27qs7oej1f23" --no-password --data-only --table "\"user\"" --schema xyz1 --verbose "E:\20150611 Mig32QA user4.backup"


--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


On Mon, Jun 15, 2015 at 11:04 PM, Soule, Cathi (HQP) <cathi.soule@roberthalf.com> wrote:

Hello,

 

We are not able to restore a table using pgAdmin from object browser.  We have been successful using backup / restore functions with 30 other tables.  However, we are not able to restore one table named ‘user’.  Here are details:  Thank you!

 

-          pgAdmin version 1.20.0

-          Windows 7, 64-bit

 

Messages returned is as follows.  Note that a successful restore had 2 additional msgs (pg_restore: processing data for table "skillc" pg_restore: setting owner and privileges for TABLE DATA skillc). Defaults were used on backup and restore.  Does anyone know how to resolve? Thank you for any help!   

 

 

MESSAGES RETURNED FROM UNSUCCESSFUL RESTORE--

C:/Program Files/PostgreSQL/9.4/bin\pg_restore.exe --host localhost --port

5432 --username "postgres" --dbname "d27qs7oej1f23" --no-password --data-only --table \"user\" --schema xyz1 --verbose "E:\20150611 Mig32QA user4.backup"

pg_restore: connecting to database for restore  Process returned exit code 0.

 

 

 

Cathi Soule

Cathi.Soule@roberthalf.com

 


В списке pgadmin-support по дате отправления: