From: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | "Soule, Cathi (HQP)" <cathi(dot)soule(at)roberthalf(dot)com> |
Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Unable to Restor Table Named "User" |
Date: | 2015-06-15 17:50:11 |
Message-ID: | CAG7mmozE2nfKnb1jDLhAbVfE_kXsw+kCS0kwYC3R8ugGc10YDA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.enterprisedb.com>
*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>
On Mon, Jun 15, 2015 at 11:04 PM, Soule, Cathi (HQP) <
cathi(dot)soule(at)roberthalf(dot)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(dot)Soule(at)roberthalf(dot)com
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2015-06-15 17:50:21 | Re: Unable to Restor Table Named "User" |
Previous Message | Soule, Cathi (HQP) | 2015-06-15 17:34:54 | Unable to Restor Table Named "User" |