On Wed, Dec 10, 2008 at 6:41 AM, Alexander Farber <alexander.farber@xxxxxxxxx> wrote: > Hello, > > 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: That's not directly supported. The other direction is. You could try dumpig the 8.2 database with the 8.1 dump, but it's not guaranteed to work either. > Does anybody please know what's wrong here > (some new syntax introduced in 8.2.x)? Yep. > And what could I do to workaround it > (I have to use CentOS and would like to use its native PostgreSQL 8.1) Create the same basic thing by hand in 8.1 and dump it and see what the syntax looks like. Now write a script to transform your 8.2 dump into that format. OR upgrade your 8.1 machine to 8.2 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
