"Alexander Farber" <alexander.farber@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
