From: | "Soule, Cathi (HQP)" <cathi(dot)soule(at)roberthalf(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #13438: Restore using GUI client - Data Not Loading |
Date: | 2015-06-15 14:37:09 |
Message-ID: | 6FE8E301C4B5FB469E9FDEDACEF27D94AF5763@N1-1EXC-MBX06N2.na.msds.rhi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Saturday, June 13, 2015 8:57 AM
To: Soule, Cathi (HQP)
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #13438: Restore using GUI client - Data Not Loading
cathi(dot)soule(at)roberthalf(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Soule, Cathi (HQP) | 2015-06-15 15:29:27 | Re: BUG #13438: Restore using GUI client - Data Not Loading |
Previous Message | Tom Lane | 2015-06-15 12:55:33 | Re: BUG #13440: unaccent does not remove all diacritics |