Обсуждение: Restoring sequence values

Hello!

Is there any way to restore the value of sequences when using
pg_restore on a custom format (pg_dump -c) dump file?


Also is there an easy way to copy a database from one machine to
another?

I have tried using pg_dump/pg_restore, but this does not work well
because the order of the objects get mixed up (Lots of foreign keys
etc.) I have tried using a list file, but wading through hundreds of
functions is tedious.

Thanks

Bendik Rognlien Johansen <bendik.johansen@gmail.com> writes:
> Is there any way to restore the value of sequences when using
> pg_restore on a custom format (pg_dump -c) dump file?

It should happen automatically.

> Also is there an easy way to copy a database from one machine to
> another?
> I have tried using pg_dump/pg_restore, but this does not work well
> because the order of the objects get mixed up (Lots of foreign keys
> etc.)

This should work properly if using 8.0 or later pg_dump; older versions
were a few bricks shy of a load :-(.  If it *is* 8.0, please post
details to pgsql-bugs.

            regards, tom lane