On 01/13/2014 01:43 PM, Day, David wrote:
Hi,
This is sort of a continuation of = problems I was working on last week
with selective restorations of an archive file at the schema or table
level. ( V9.3)
Given that I dumped the entire database ( pg_dump –Fc my_db –f
archive_file )
When I pg_restore an entire schema ( -n ) everything is wonderful.
If I try to attempt two tables in one of the schemas I encounter problems.
I get a success of sort with these option variations:
pg_restore -c -t tbl1 –t tbl2 –U <username> -d my_db archive_file
In this case the tables are recreated with data but all the original
constraints for these tables are missing
As are triggers that are associated with the tables. I guess I can
understand this.
I just tried something similar here and I am not seeing that. I see
constraints and triggers.
Is there anything in the log that might help?
Is this a bug or a mis-understanding on my part?
One thing you can do to help see what is going on is restore to a file
instead of the database. This creates a plain text file with the SQL
statements. So:
pg_restore -c -t tbl1 –t tbl2 –U <username> -f plain_text.sql
archive_file
Regards
Dave Day
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
