Discussion:
sequence not set with pg_restore
(too old to reply)
Randall Smith
2004-10-12 16:22:47 UTC
Permalink
I'm dumped a database on 7.4.0.3 using pg_restore -Fc mydb > mydb.dump.

I then restored it using pg_restore -d dwstest -U dba mydb.dump on
another server running 7.4.5-3.

After importing, all of the sequences are set to 0. Did I miss a step?

Randall
Randall Smith
2004-10-12 21:30:55 UTC
Permalink
Post by Randall Smith
I'm dumped a database on 7.4.0.3 using pg_restore -Fc mydb > mydb.dump.
I then restored it using pg_restore -d dwstest -U dba mydb.dump on
another server running 7.4.5-3.
After importing, all of the sequences are set to 0. Did I miss a step?
Randall
As a note, using pg_dump with plain text format does not have this
problem. So is there a bug in the custom format?

Randall
Tom Lane
2004-10-12 22:16:55 UTC
Permalink
Post by Randall Smith
As a note, using pg_dump with plain text format does not have this
problem. So is there a bug in the custom format?
Not in general, but feel free to show us a reproducible test case...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

Loading...