"Alexander Farber" <[EMAIL PROTECTED]> writes:
> I've pg_dump'ed a database from PostgreSQL 8.2.6 / openSUSE 10.3
> and now trying to load it as a "postgres" user at 8.1.1 / CentOS 5.2
> and get numerous errors like:

In general there is no promise that you can load pg_dump output into
previous server versions.  You'll need to edit the file by hand if you
want to do this.

> (I have to use CentOS and would like to use its native PostgreSQL 8.1)

Even if you have to use CentOS, using 8.1.1 is a horrid idea --- the
current 8.1 release is 8.1.15.  Try to get a more up-to-date copy
of CentOS.

However, there's really no very good reason not to install 8.2 or 8.3
from the RPMs that the Postgres project offers.

                        regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to