pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
sequence not set with pg_restore
3+ messages / 2 participants
[nested] [flat]

* sequence not set with pg_restore
@ 2004-10-12 16:22 Randall Smith <randall@tnr.cc>
  2004-10-12 21:30 ` Re: sequence not set with pg_restore Randall Smith <randall@tnr.cc>
  0 siblings, 1 reply; 3+ messages in thread

From: Randall Smith @ 2004-10-12 16:22 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: sequence not set with pg_restore
  2004-10-12 16:22 sequence not set with pg_restore Randall Smith <randall@tnr.cc>
@ 2004-10-12 21:30 ` Randall Smith <randall@tnr.cc>
  2004-10-12 22:16   ` Re: sequence not set with pg_restore Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Randall Smith @ 2004-10-12 21:30 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: sequence not set with pg_restore
  2004-10-12 16:22 sequence not set with pg_restore Randall Smith <randall@tnr.cc>
  2004-10-12 21:30 ` Re: sequence not set with pg_restore Randall Smith <randall@tnr.cc>
@ 2004-10-12 22:16   ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-10-12 22:16 UTC (permalink / raw)
  To: Randall Smith <randall@tnr.cc>; +Cc: pgsql-admin

Randall Smith <randall@tnr.cc> writes:
> 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-10-12 22:16 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-12 16:22 sequence not set with pg_restore Randall Smith <randall@tnr.cc>
2004-10-12 21:30 ` Randall Smith <randall@tnr.cc>
2004-10-12 22:16   ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox