Re: 8.2.6 -> 8.1.11: syntax error at or near "OWNED BY"

"Alexander Farber" <alexander.farber@gmail.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