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:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 8:46 PM To: Laurens Wagemakers Cc: '[EMAIL PROTECTED]' Subject: Re: [ADMIN] PG_DUMP / PG_RESTORE Laurens Wagemakers <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
