sequence not set with pg_restore

From: Randall Smith <randall(at)tnr(dot)cc>
To: pgsql-admin(at)postgresql(dot)org
Subject: sequence not set with pg_restore
Date: 2004-10-12 16:22:47
Message-ID: txTad.35642$Lo6.33296@fed1read03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dan Hrabarchuk 2004-10-12 18:34:25 Re: [Fwd: zero_damaged_pages having no effect]
Previous Message Tom Lane 2004-10-12 16:01:05 Re: [Fwd: zero_damaged_pages having no effect]