Postgres Pro
Downloads
Home   >   mailing lists

Re: sequence not set with pg_restore - Mailing list pgsql-admin

From Randall Smith
Subject Re: sequence not set with pg_restore
Date
Msg-id j2Yad.16064$_g6.11879@okepread03
Whole thread Raw
In response to sequence not set with pg_restore  (Randall Smith <randall@tnr.cc>)
Responses Re: sequence not set with pg_restore
List pgsql-admin
Tree view 
Randall Smith wrote:
> 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

pgsql-admin by date:

Previous
From: Dan Hrabarchuk
Date:
Subject: Re: [Fwd: zero_damaged_pages having no effect]
Next
From: Tom Lane
Date:
Subject: Re: sequence not set with pg_restore