robert <robert@xxxxxxxxx> writes: > I use > pg_dump -h localhost -U USER -Fc DATABASE > dumpfile OK ... > then I restore it with: > dropdb DATABASE > pg_restore -O -U user -d DATABASE dumpfile That sequence is missing a createdb step (or else -C in the restore switches). > doing this then I get these warnings, and many (not all) sequences are not created. Usually the thing to do is look at the very first error; everything after that may just be cascading damage. I kinda doubt what you showed us here is the first error. regards, tom lane
