PG_DUMP / PG_RESTORE

[Laurens Wagemakers]

Hi all,

Running postgresql 7.1.3 on Solaris 9:
Restoring a database from a RH 7.3 Postgresql 7.1 version

Get the message:
CREATE SEQUENCE "live_autoincrement" start 1 increment 1 maxvalue
92233720368547
75807 minvalue 1 cache 1;
ERROR: parser: parse error at or near "9223372036854775807"

(set query logging on)

Looked at a message from Tom Lane on Date: Tue, 06 Aug 2002 23:21:14 -0400
however no answer for it.

Any solutions,

Regards,

Laurens

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Tom Lane]

Post by Laurens Wagemakers
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.

Post by Laurens Wagemakers
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 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Laurens Wagemakers]

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:***@sss.pgh.pa.us]
Sent: Tuesday, May 25, 2004 8:46 PM
To: Laurens Wagemakers
Cc: 'pgsql-***@postgresql.org'
Subject: Re: [ADMIN] PG_DUMP / PG_RESTORE

Post by Laurens Wagemakers
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.

Post by Laurens Wagemakers
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 ***@postgresql.org so that your
message can get through to the mailing list cleanly