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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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 know 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.

Thank you very much for your help,

Cathi Soule

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

To clarify - we are trying to restore the 'user' table using pgAdmin III 'restore' function. This function is selected after right-click on table in schema in Object browser. We successfully used 'backup' and 'restore' in pgAdmin III GUI on 30 tables. This 'user' table has been the only issue. Thanks again for your help.

-----Original Message-----
From: Soule, Cathi (HQP)
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 know 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.

Thank you very much for your help,

Cathi Soule

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

"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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs