Thread: Problems with dump
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
Ricardo Valença
UEAD - UGF
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/