Restoring sequence values - Mailing list pgsql-novice

From Bendik Rognlien Johansen
Subject Restoring sequence values
Date
Msg-id 29CBBDCD-A74F-4D3C-AFAF-A20FA99A9507@gmail.com
Whole thread Raw
Responses Re: Restoring sequence values
List pgsql-novice
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

pgsql-novice by date:

Previous
From: George Weaver
Date:
Subject: Re: Problem getting xml2 contrib module working with 8.1
Next
From: Tom Lane
Date:
Subject: Re: Restoring sequence values