Again you got it right although my customer was sure he had 7.1 running I
asked him to run psql -V which resolved version 7.2.1
Thanx,
Laurens
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, May 25, 2004 8:46 PM
To: Laurens Wagemakers
Cc: 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN] PG_DUMP / PG_RESTORE
Laurens Wagemakers <l.wagemakers@truston.com> writes:
> Running postgresql 7.1.3 on Solaris 9:
> Restoring a database from a RH 7.3 Postgresql 7.1 version
You generally aren't going to be able to restore a dump into an older
version without some manual labor.
> CREATE SEQUENCE "live_autoincrement" start 1 increment 1 maxvalue
> 92233720368547
> 75807 minvalue 1 cache 1;
> ERROR: parser: parse error at or near "9223372036854775807"
In this particular case the issue is that 7.1 didn't have 64-bit
sequence values. (No, I don't think your RH database is 7.1 ...)
regards, tom lane