Re: Unable to Restor Table Named "User"

"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(dot)soule(at)roberthalf(dot)com>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Sent: Monday, June 15, 2015 1:34 PM
Subject: [pgadmin-support] Unable to Restor Table Named "User"

<!--#yiv2649048350 _filtered #yiv2649048350 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv2649048350 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv2649048350 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv2649048350 {font-family:"Lucida Calligraphy";panose-1:3 1 1 1 1 1 1 1 1 1;}#yiv2649048350 #yiv2649048350 p.yiv2649048350MsoNormal, #yiv2649048350 li.yiv2649048350MsoNormal, #yiv2649048350 div.yiv2649048350MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";}#yiv2649048350 a:link, #yiv2649048350 span.yiv2649048350MsoHyperlink {color:blue;text-decoration:underline;}#yiv2649048350 a:visited, #yiv2649048350 span.yiv2649048350MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv2649048350 p.yiv2649048350MsoPlainText, #yiv2649048350 li.yiv2649048350MsoPlainText, #yiv2649048350 div.yiv2649048350MsoPlainText {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";}#yiv2649048350 p.yiv2649048350MsoListParagraph, #yiv2649048350 li.yiv2649048350MsoListParagraph, #yiv2649048350 div.yiv2649048350MsoListParagraph {margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";}#yiv2649048350 span.yiv2649048350EmailStyle17 {font-family:"Calibri", "sans-serif";color:windowtext;}#yiv2649048350 span.yiv2649048350PlainTextChar {font-family:"Calibri", "sans-serif";}#yiv2649048350 .yiv2649048350MsoChpDefault {font-family:"Calibri", "sans-serif";} _filtered #yiv2649048350 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv2649048350 div.yiv2649048350WordSection1 {}#yiv2649048350 _filtered #yiv2649048350 {} _filtered #yiv2649048350 {font-family:"Calibri", "sans-serif";} _filtered #yiv2649048350 {font-family:"Courier New";} _filtered #yiv2649048350 {font-family:Wingdings;} _filtered #yiv2649048350 {font-family:Symbol;} _filtered #yiv2649048350 {font-family:"Courier New";} _filtered #yiv2649048350 {font-family:Wingdings;} _filtered #yiv2649048350 {font-family:Symbol;} _filtered #yiv2649048350 {font-family:"Courier New";} _filtered #yiv2649048350 {font-family:Wingdings;}#yiv2649048350 ol {margin-bottom:0in;}#yiv2649048350 ul {margin-bottom:0in;}-->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