Postgres Pro
Downloads
Home   >   mailing lists

sequence not set with pg_restore - Mailing list pgsql-admin

From Randall Smith
Subject sequence not set with pg_restore
Date
Msg-id txTad.35642$Lo6.33296@fed1read03
Whole thread Raw
Responses Re: sequence not set with pg_restore
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [Fwd: zero_damaged_pages having no effect]
Next
From: Dan Hrabarchuk
Date:
Subject: Re: [Fwd: zero_damaged_pages having no effect]