Re: sequence not set with pg_restore

From: Randall Smith <randall(at)tnr(dot)cc>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: sequence not set with pg_restore
Date: 2004-10-12 21:30:55
Message-ID: j2Yad.16064$_g6.11879@okepread03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-10-12 22:16:55 Re: sequence not set with pg_restore
Previous Message Dan Hrabarchuk 2004-10-12 18:34:25 Re: [Fwd: zero_damaged_pages having no effect]