Re: Problems with dump - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: Problems with dump
Date
Msg-id 20050216005417.GA13781@winnie.fuhr.org
Whole thread Raw
In response to Problems with dump  (Ricardo Valença de Assis <valenca@campusvirtual.br>)
List pgsql-admin
On Tue, Feb 15, 2005 at 08:50:53AM -0300, Ricardo Valença de Assis wrote:
>
> I'm trying to migrate a database from one server to another but I got
> a hard problem. All the tables and sequences are migrated but the field
> last_value of ALL sequences is set to 1. Why this? The others fields of
> them are set correctly but last_value it not. Is there a way to dump
> only sequences?

What versions of PostgreSQL are the servers running?  What commands
did you run to dump and restore the database?  Does a restore print
errors?  If so, what are they?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: who is best for support?
Next
From: "John Jensen"
Date:
Subject: Re: who is best for support?