I tried the latest pg_migrator
(http://pgfoundry.org/frs/download.php/2291/pg_migrator-8.4.tgz) to
migrate a database from an 8.3.7 to an 8.4.0 cluster. It finished with
a success message, and the schema and all tables seem to have been
migrated correctly.

However, all of the sequences were at the initial values and not
bumped up to the last used value as I would have expected. The first
nextval call on any sequence in the migrated 8.4 database always
returned 1.

Is this behaviour intended for some reason, or a bug?


Til

Responses

• Re: [GENERAL] pg_migrator not setting values of sequences? at 2009-07-13 22:29:36 from Bruce Momjian
• Re: pg_migrator not setting values of sequences? at 2009-07-13 22:30:17 from Bruce Momjian

pgsql-hackers by date

Next:	From: Peter Eisentraut	Date: 2009-07-13 22:02:54
	Subject: Re: Mostly Harmless: c++reserved - patch 1 of 4
Previous:	From: Peter Eisentraut	Date: 2009-07-13 21:55:33
	Subject: Re: Mostly Harmless: c++configure - patch 3 of 4

pgsql-general by date

Next:	From: Jamie Fox	Date: 2009-07-13 22:21:39
	Subject: Re: large object does not exist after pg_migrator
Previous:	From: Michael Glaesemann	Date: 2009-07-13 21:45:06
	Subject: Re: Benetl, a free ETL tool for files using postgreSQL, is out in version 2.9