Re: BUG #13438: Restore using GUI client - Data Not Loading

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