Обсуждение: Problems with dump

Поиск
Список
Период
Сортировка

Problems with dump

От
Ricardo Valença de Assis
Дата:
Hello World!
 
    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?
 
Thanks!
 
Att.
Ricardo Valença
UEAD - UGF

Re: Problems with dump

От
Michael Fuhr
Дата:
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/