i am having a problem with dump and restore. basically i have 2
databases
maindb and tempdb
the databases are almost the same but the main db has some extra
tables which dont change. what i need to do is get all the information
form the temp db and put it in the main db. the tempdb should
overwri
Hi,
What you are trying to do should be possible as far as I know.
Did you use the custom format for your dump (pg_dump -Fc)? Try extracting a
list of contents of the dump (pg_restore --list) option and check that for
anything that might be causing you to lose that table. Comment out any
offendi