Re: Problems with dump

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Ricardo Valença de Assis <valenca(at)campusvirtual(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems with dump
Date: 2005-02-16 00:54:17
Message-ID: 20050216005417.GA13781@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message John Jensen 2005-02-16 08:23:01 Re: who is best for support?
Previous Message Scott Marlowe 2005-02-15 21:30:09 Re: who is best for support?