Unable to Restor Table Named "User"

From: "Soule, Cathi (HQP)" <cathi(dot)soule(at)roberthalf(dot)com>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Unable to Restor Table Named "User"
Date: 2015-06-15 17:34:54
Message-ID: 6FE8E301C4B5FB469E9FDEDACEF27D94AF596C@N1-1EXC-MBX06N2.na.msds.rhi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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<mailto:Cathi(dot)Soule(at)roberthalf(dot)com>

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Ashesh Vashi 2015-06-15 17:50:11 Re: Unable to Restor Table Named "User"
Previous Message Jan-Peter Seifert 2015-06-15 09:39:21 Naming of 'valid until' in role properties