From: | cathi(dot)soule(at)roberthalf(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #13438: Restore using GUI client - Data Not Loading |
Date: | 2015-06-12 18:50:20 |
Message-ID: | 20150612185020.32367.54876@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13438
Logged by: cathi soule
Email address: cathi(dot)soule(at)roberthalf(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2015-06-12 19:47:17 | Re: Lack of Sanity Checking in file 'pctcl.c' for PostgreSQL 9.4.x |
Previous Message | Andres Freund | 2015-06-12 13:24:11 | Re: BUG #13437: Seq Scan increases heap_blks_read instead of heap_blks_hit when no disk is read |