Skip site navigation (1) Skip section navigation (2)

Re: PG_DUMP / PG_RESTORE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laurens Wagemakers <l(dot)wagemakers(at)truston(dot)com>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PG_DUMP / PG_RESTORE
Date: 2004-05-25 18:45:31
Message-ID: 26179.1085510731@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Laurens Wagemakers <l(dot)wagemakers(at)truston(dot)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

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2004-05-25 18:51:26
Subject: Re: pg_hba.conf
Previous:From: LSanchezDate: 2004-05-25 17:13:59
Subject: Re: pg_hba.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group