469,625 Members | 998 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

pg_dump and pg_restore problems

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?


/Otto Blomqvist
Nov 23 '05 #1
0 1245

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Sam | last post: by
7 posts views Thread by Howard Lowndes | last post: by
1 post views Thread by Ruth Hsieh | last post: by
11 posts views Thread by Ben Marklein | last post: by
6 posts views Thread by Michal Hlavac | last post: by
1 post views Thread by Neil Zanella | last post: by
reply views Thread by aktivo | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.