From: | o(dot)blomqvist(at)secomintl(dot)com (Otto Blomqvist) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump and pg_restore problems |
Date: | 2004-07-01 00:11:13 |
Message-ID: | c501cb7d.0406301611.6966ae2d@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello !
I was just wondering if anyone knows if this is a bug or whats up.
Im using psql 7.2.2
I can do full restores and dumps all day long, however when I do the
following I run into problems
Do a full dump with pg_dump -Fc -O Database1 > dump.tar
I restore one table to Database1 using
pg_restore -t table_25 -c -O -d database1 dump.tar
I dump database1 again
pg_dump -Fc -O Database1 > dump2.tar
Then I create a new Database and attempt a full pg_restore into the
new DB. Which, does not work. It does not restore the database but
throws me a "table_25 relation does not exist" - message instead. But
the table_25 is present in database1, it just seems like the dump does
not see it, after a partial restore.
Any ideas?
Thanks
/Otto Blomqvist
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Cashell | 2004-07-01 00:57:35 | Problems restarting after database crashed (signal 11). |
Previous Message | mallah | 2004-07-01 00:04:45 | case for lock_timeout |