Thread: Unable to Restor Table Named "User"

Unable to Restor Table Named "User"

From

"Soule, Cathi (HQP)"

Date:

15 June 2015, 20:36:15

<div class="WordSection1"><p class="MsoNormal">Hello,<p class="MsoNormal"> <p class="MsoNormal">We are not able to
restorea table using pgAdmin from object browser.  We have been successful using backup / restore functions with 30
othertables.  However, we are not able to restore one table named ‘user’.  Here are details:  Thank you!<p
class="MsoNormal"> <pclass="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span
style="mso-list:Ignore">-<spanstyle="font:7.0pt "Times New Roman"">          </span></span>pgAdmin version 1.20.0<p
class="MsoListParagraph"style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">-<span
style="font:7.0pt"Times New Roman"">          </span></span>Windows 7, 64-bit<p class="MsoNormal"> <p
class="MsoNormal">Messagesreturned is as follows.  Note that a successful restore had 2 additional msgs (pg_restore:
processingdata for table "skillc" pg_restore: setting owner and privileges for TABLE DATA skillc). Defaults were used
onbackup and restore.  Does anyone know how to resolve? Thank you for any help!   <p class="MsoPlainText"> <p
class="MsoPlainText"> <pclass="MsoPlainText">MESSAGES RETURNED FROM UNSUCCESSFUL RESTORE--<p
class="MsoPlainText">C:/ProgramFiles/PostgreSQL/9.4/bin\pg_restore.exe --host localhost --port<p
class="MsoPlainText">5432--username "postgres" --dbname "d27qs7oej1f23" --no-password --data-only --table \"user\"
--schemaxyz1 --verbose "E:\20150611 Mig32QA user4.backup"<p class="MsoPlainText">pg_restore: connecting to database for
restore Process returned exit code 0. <p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal"><spanstyle="font-family:"Lucida Calligraphy"">Cathi Soule</span><p class="MsoNormal"><a
href="mailto:Cathi.Soule@roberthalf.com"><spanstyle="color:blue">Cathi.Soule@roberthalf.com</span></a><p
class="MsoNormal"> </div>

Re: Unable to Restor Table Named "User"

From

Melvin Davidson

Date:

15 June 2015, 20:50:33

"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!   
  
  
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
  

Re: Unable to Restor Table Named "User"

From

Ashesh Vashi

Date:

15 June 2015, 20:50:38

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

Re: Unable to Restor Table Named "User"

From

"Soule, Cathi (HQP)"

Date:

15 June 2015, 22:30:14

Hi Melvin, Still not working for me – sorry I am new to Postgres and not a unix person--- Any help you can provide is much appreciated.

--The data is not being restored for table ‘user’. It appears that the ‘process returned exit code 0’ msg is for the first step only (connecting to database). Listed below are msgs from 1 of the other 30 backup/restores that were successful – note that there are 2 additional steps (in green) on the successful restore that are not generated for the unsuccessful restore--

--No error file was located.

-- Config settings—

#log_min_messages = warning

#log_min_error_statement = error

--This statement did not produce any results – not can I find an error file

pg_restore -t user -d "u91uqv3kafdja7" "E:\20150611 Mig32QA user5.backup"

SAMPLE SUCCESSFUL RESTORE--

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

pg_restore: connecting to database for restore

pg_restore: processing data for table "skill__c"

pg_restore: setting owner and privileges for TABLE DATA skill__c

Process returned exit code 0.

UNSUCCESSFUL RESTORE TO A TABLE NAMED USER

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 salesforce_mig32 --verbose "E:\20150611 Mig32QA user4.backup"

pg_restore: connecting to database for restore

Process returned exit code 0.

From: Melvin Davidson [mailto:melvin6925@yahoo.com]
Sent: Monday, June 15, 2015 10:50 AM
To: Soule, Cathi (HQP); pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] 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.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!

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

Re: Unable to Restor Table Named "User"

From

Melvin Davidson

Date:

15 June 2015, 22:54:12

Cathi,

If the restore command is reporting no errors "Process returned exit code 0.", but the table exists and has no data, then it is quite probable that
A. The backup was made when there was no data in the table
OR
B. The backup of the user table was made with the 
 -s or -schema-only flag, which means do not back up data.

I suggest you make a copy of the user backup file and then look through the copy to make sure that data exists there.

FYI, pg_dump does not an create error file, ALL errors are logged to the PostgreSQL error file, which is specified by log_directory and log_filename in postgresql.conf.

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: Melvin Davidson <melvin6925@yahoo.com>; "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org> 
Sent: Monday, June 15, 2015 3:29 PM
Subject: RE: [pgadmin-support] Unable to Restor Table Named "User"

#yiv0723975810    --  filtered  {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}
#yiv0723975810  filtered  {font-family:Courier;panose-1:2 7 4 9 2 2 5 2 4 4;}
#yiv0723975810  filtered  {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
#yiv0723975810  filtered  {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
#yiv0723975810  filtered  {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
#yiv0723975810  filtered  {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
#yiv0723975810     p.yiv0723975810MsoNormal, #yiv0723975810   li.yiv0723975810MsoNormal, #yiv0723975810   div.yiv0723975810MsoNormal	{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}
#yiv0723975810   a:link, #yiv0723975810   span.yiv0723975810MsoHyperlink	{color:blue;text-decoration:underline;}
#yiv0723975810   a:visited, #yiv0723975810   span.yiv0723975810MsoHyperlinkFollowed	{color:purple;text-decoration:underline;}
#yiv0723975810   p.yiv0723975810MsoAcetate, #yiv0723975810   li.yiv0723975810MsoAcetate, #yiv0723975810   div.yiv0723975810MsoAcetate	{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}
#yiv0723975810   p.yiv0723975810MsoNoSpacing, #yiv0723975810   li.yiv0723975810MsoNoSpacing, #yiv0723975810   div.yiv0723975810MsoNoSpacing	{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}
#yiv0723975810   p.yiv0723975810MsoListParagraph, #yiv0723975810   li.yiv0723975810MsoListParagraph, #yiv0723975810   div.yiv0723975810MsoListParagraph	{margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;font-size:12.0pt;}
#yiv0723975810   p.yiv0723975810msoplaintext, #yiv0723975810   li.yiv0723975810msoplaintext, #yiv0723975810   div.yiv0723975810msoplaintext	{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#yiv0723975810   p.yiv0723975810msolistparagraph, #yiv0723975810   li.yiv0723975810msolistparagraph, #yiv0723975810   div.yiv0723975810msolistparagraph	{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#yiv0723975810   p.yiv0723975810msonormal, #yiv0723975810   li.yiv0723975810msonormal, #yiv0723975810   div.yiv0723975810msonormal	{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#yiv0723975810   p.yiv0723975810msochpdefault, #yiv0723975810   li.yiv0723975810msochpdefault, #yiv0723975810   div.yiv0723975810msochpdefault	{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#yiv0723975810   span.yiv0723975810msohyperlink	{}
#yiv0723975810   span.yiv0723975810msohyperlinkfollowed	{}
#yiv0723975810   span.yiv0723975810emailstyle17	{}
#yiv0723975810   span.yiv0723975810plaintextchar	{}
#yiv0723975810   p.yiv0723975810msonormal1, #yiv0723975810   li.yiv0723975810msonormal1, #yiv0723975810   div.yiv0723975810msonormal1	{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}
#yiv0723975810   span.yiv0723975810msohyperlink1	{color:blue;text-decoration:underline;}
#yiv0723975810   span.yiv0723975810msohyperlinkfollowed1	{color:purple;text-decoration:underline;}
#yiv0723975810   p.yiv0723975810msoplaintext1, #yiv0723975810   li.yiv0723975810msoplaintext1, #yiv0723975810   div.yiv0723975810msoplaintext1	{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}
#yiv0723975810   p.yiv0723975810msolistparagraph1, #yiv0723975810   li.yiv0723975810msolistparagraph1, #yiv0723975810   div.yiv0723975810msolistparagraph1	{margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;font-size:11.0pt;}
#yiv0723975810   span.yiv0723975810emailstyle171	{color:windowtext;}
#yiv0723975810   span.yiv0723975810plaintextchar1	{}
#yiv0723975810   p.yiv0723975810msochpdefault1, #yiv0723975810   li.yiv0723975810msochpdefault1, #yiv0723975810   div.yiv0723975810msochpdefault1	{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#yiv0723975810   span.yiv0723975810BalloonTextChar	{}
#yiv0723975810   span.yiv0723975810EmailStyle35	{color:#1F497D;}
#yiv0723975810   .yiv0723975810MsoChpDefault	{font-size:10.0pt;}
#yiv0723975810  filtered  {margin:1.0in 1.0in 1.0in 1.0in;}
#yiv0723975810   div.yiv0723975810WordSection1	{}
#yiv0723975810     filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810  filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810  filtered  {font-family:Symbol;}
#yiv0723975810  filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810  filtered  {font-family:Symbol;}
#yiv0723975810  filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810  filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810  filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810  filtered  {font-family:Symbol;}
#yiv0723975810  filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810  filtered  {font-family:Symbol;}
#yiv0723975810  filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810  filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810  filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810  filtered  {font-family:Symbol;}
#yiv0723975810  filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810  filtered  {font-family:Symbol;}
#yiv0723975810  filtered  {}
#yiv0723975810  filtered  {font-family:Wingdings;}
#yiv0723975810   ol	{margin-bottom:0in;}
#yiv0723975810   ul	{margin-bottom:0in;}
#yiv0723975810 Hi Melvin,  Still not working for me – sorry I am new to Postgres and not a unix person---  Any help you can provide is much appreciated.  
  
--The data is not being restored for table ‘user’.  It appears that the ‘process returned exit code 0’ msg is for the first step only (connecting to database).  Listed below are msgs from 1 of the other 30 backup/restores that were successful – note that there are 2 additional steps (in green) on the successful restore that are not generated for the unsuccessful restore--
  
--No error file was located.
  
-- Config settings—
#log_min_messages = warning                 
#log_min_error_statement = error
  
--This statement did not produce any results – not can I find an error file 
pg_restore -t user -d "u91uqv3kafdja7" "E:\20150611 Mig32QA user5.backup"
  
SAMPLE SUCCESSFUL RESTORE--
C:/Program Files/PostgreSQL/9.4/bin\pg_restore.exe --host localhost --port 5432 --username "postgres" --dbname "d27qs7oej1f23" --no-password  --data-only --table skill__c --schema salesforce_mig32 --verbose "E:\20150611 Mig32QA skill.backup"
pg_restore: connecting to database for restore
pg_restore: processing data for table "skill__c"
pg_restore: setting owner and privileges for TABLE DATA skill__c
Process returned exit code 0.
  
UNSUCCESSFUL RESTORE TO A TABLE NAMED USER
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 salesforce_mig32 --verbose "E:\20150611 Mig32QA user4.backup"
pg_restore: connecting to database for restore
Process returned exit code 0.
  
  
  


From: Melvin Davidson [mailto:melvin6925@yahoo.com] 
Sent: Monday, June 15, 2015 10:50 AM
To: Soule, Cathi (HQP); pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] 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.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!   
 
 
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
 
  

Re: Unable to Restor Table Named "User"

From

"Soule, Cathi (HQP)"

Date:

15 June 2015, 23:30:55

Is this what you mean? If so, no success. Or should I try something else? I really appreciate your help.

From: Ashesh Vashi [mailto:ashesh.vashi@enterprisedb.com]
Sent: Monday, June 15, 2015 10:50 AM
To: Soule, Cathi (HQP)
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Unable to Restor Table Named "User"

Try this command on the command-prompt:

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,

- pgAdmin version 1.20.0

- Windows 7, 64-bit

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

Thread: Unable to Restor Table Named "User"

Unable to Restor Table Named "User"

Re: Unable to Restor Table Named "User"

Re: Unable to Restor Table Named "User"

Re: Unable to Restor Table Named "User"

Re: Unable to Restor Table Named "User"

Re: Unable to Restor Table Named "User"

Attachment