"Process returned exit code 0." Indicates No errors occurred during the restore, so I do not understand what exactly your problem is. Are there any errors in the PostgreSQL error log file with regards to your "user" table? What is the setting for log_min_messages & log_min_error_statement in postgresql.conf?
Try restoring by specifying just the user table.
IOW: pg_restore -t user -d yourdb your_dump_file
Then see if any errors are returned.
Melvin Davidson
Cell 720-320-0155
Folk Alley - All Folk - 24 Hours a day www.folkalley.com
From: "Soule, Cathi (HQP)" <cathi.soule@roberthalf.com> To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org> Sent: Monday, June 15, 2015 1:34 PM Subject: [pgadmin-support] Unable to Restor Table Named "User"
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!
