Thread: BUG #13438: Restore using GUI client - Data Not Loading
The following bug has been logged on the website: Bug reference: 13438 Logged by: cathi soule Email address: cathi.soule@roberthalf.com PostgreSQL version: 9.4.2 Operating system: windows Description: Hello, I am trying to backup / restore a table named 'user' using Postgres GUI/client. The restore does not load data. I suspect the issue may be the tablename 'user' (not my table). The backup msgs are listed below. My other successful restores 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! 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@roberthalf.com writes:
> Hello, I am trying to backup / restore a table named 'user' using Postgres
> GUI/client. The restore does not load data. I suspect the issue may be the
> tablename 'user' (not my table). The backup msgs are listed below. My other
> successful restores 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!
> 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.
I'm not real sure what backslashes do in the Windows command interpreter,
but I bet the problem is that what pg_restore is getting as the argument
of the --table switch is not just user but something with quote marks
and/or backslashes in it, and that's not matching any table name it can
find in the file so it doesn't restore anything.
Try leaving off all that decoration. "user" is not a keyword as far
as the shell is concerned, so it doesn't really need quoting in this
context.
regards, tom lane
On 6/13/2015 8:57 AM, Tom Lane wrote: > cathi.soule@roberthalf.com writes: >> >Hello, I am trying to backup / restore a table named 'user' using Postgres >> >GUI/client. The restore does not load data. I suspect the issue may be the >> >tablename 'user' (not my table). The backup msgs are listed below. My other >> >successful restores 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! >> > 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. > I'm not real sure what backslashes do in the Windows command interpreter, > but I bet the problem is that what pg_restore is getting as the argument > of the --table switch is not just user but something with quote marks > and/or backslashes in it, and that's not matching any table name it can > find in the file so it doesn't restore anything. > > Try leaving off all that decoration. "user" is not a keyword as far > as the shell is concerned, so it doesn't really need quoting in this > context. A) they are using a GUI, so that command was autogenerated by something (pg_admin ?) B) they said this was the output of the backup, yet its pg_restore... -- john r pierce, recycling bits in santa cruz
Hi Tom,
I am using the GUI to try and 'restore' the 'user' table - which was backed=
up using the GUI 'backup' function. Is there a way to 'leave off all that=
decoration' as you suggest below - using the GUI? Unfortunately I don't k=
now my way around in native environment. We do have 'PSQL Console' plugin =
- although I have not been successful trying to restore here. That is why =
we were relying on the GUI - which worked great for all our other tables.=20
Thank you very much for your help,
Cathi Soule=20
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20
Sent: Saturday, June 13, 2015 8:57 AM
To: Soule, Cathi (HQP)
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #13438: Restore using GUI client - Data Not Loading
cathi.soule@roberthalf.com writes:
> Hello, I am trying to backup / restore a table named 'user' using=20
> Postgres GUI/client. The restore does not load data. I suspect the=20
> issue may be the tablename 'user' (not my table). The backup msgs are=20
> listed below. My other successful restores had 2 additional msgs=20
> (pg_restore: processing data for table "skillc" pg_restore: setting=20
> owner and privileges for TABLE DATA skillc). Defaults were used on=20
> backup and restore. Does anyone know how to resolve? Thank you for any he=
lp!
> C:/Program Files/PostgreSQL/9.4/bin\pg_restore.exe --host localhost=20
> --port
> 5432 --username "postgres" --dbname "d27qs7oej1f23" --no-password=20
> --data-only --table \"user\" --schema xyz1 --verbose "E:\20150611=20
> Mig32QA user4.backup"
> pg_restore: connecting to database for restore Process returned exit=20
> code 0.
I'm not real sure what backslashes do in the Windows command interpreter, b=
ut I bet the problem is that what pg_restore is getting as the argument of =
the --table switch is not just user but something with quote marks and/or b=
ackslashes in it, and that's not matching any table name it can find in the=
file so it doesn't restore anything.
Try leaving off all that decoration. "user" is not a keyword as far as the=
shell is concerned, so it doesn't really need quoting in this context.
regards, tom lane
"Soule, Cathi (HQP)" <cathi.soule@roberthalf.com> writes:
> I am using the GUI to try and 'restore' the 'user' table - which was
> backed up using the GUI 'backup' function. Is there a way to 'leave off
> all that decoration' as you suggest below - using the GUI?
Better file a bug report with the authors of whatever GUI that is; they
are using quoting rules that are unrelated to reality.
regards, tom lane
To clarify - we are trying to restore the 'user' table using pgAdmin III 'r=
estore' function. This function is selected after right-click on table in =
schema in Object browser. We successfully used 'backup' and 'restore' in p=
gAdmin III GUI on 30 tables. This 'user' table has been the only issue. T=
hanks again for your help.=20
-----Original Message-----
From: Soule, Cathi (HQP)=20
Sent: Monday, June 15, 2015 7:37 AM
To: 'Tom Lane'
Cc: pgsql-bugs@postgresql.org
Subject: RE: [BUGS] BUG #13438: Restore using GUI client - Data Not Loading
Hi Tom,
I am using the GUI to try and 'restore' the 'user' table - which was backed=
up using the GUI 'backup' function. Is there a way to 'leave off all that=
decoration' as you suggest below - using the GUI? Unfortunately I don't k=
now my way around in native environment. We do have 'PSQL Console' plugin =
- although I have not been successful trying to restore here. That is why =
we were relying on the GUI - which worked great for all our other tables.=20
Thank you very much for your help,
Cathi Soule=20
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Saturday, June 13, 2015 8:57 AM
To: Soule, Cathi (HQP)
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #13438: Restore using GUI client - Data Not Loading
cathi.soule@roberthalf.com writes:
> Hello, I am trying to backup / restore a table named 'user' using=20
> Postgres GUI/client. The restore does not load data. I suspect the=20
> issue may be the tablename 'user' (not my table). The backup msgs are=20
> listed below. My other successful restores had 2 additional msgs
> (pg_restore: processing data for table "skillc" pg_restore: setting=20
> owner and privileges for TABLE DATA skillc). Defaults were used on=20
> backup and restore. Does anyone know how to resolve? Thank you for any he=
lp!
> C:/Program Files/PostgreSQL/9.4/bin\pg_restore.exe --host localhost=20
> --port
> 5432 --username "postgres" --dbname "d27qs7oej1f23" --no-password=20
> --data-only --table \"user\" --schema xyz1 --verbose "E:\20150611=20
> Mig32QA user4.backup"
> pg_restore: connecting to database for restore Process returned exit=20
> code 0.
I'm not real sure what backslashes do in the Windows command interpreter, b=
ut I bet the problem is that what pg_restore is getting as the argument of =
the --table switch is not just user but something with quote marks and/or b=
ackslashes in it, and that's not matching any table name it can find in the=
file so it doesn't restore anything.
Try leaving off all that decoration. "user" is not a keyword as far as the=
shell is concerned, so it doesn't really need quoting in this context.
regards, tom lane