"Alexander Farber" <alexander(dot)farber(at)gmail(dot)com> 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