How export from 8.2.4 down to 8.1.8

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: How export from 8.2.4 down to 8.1.8
Date: 2007-05-20 18:15:34
Message-ID: 46509046.9070409@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I'll have to export from 8.2.4 down to 8.1.8 because our provider runs
Debian Sarge and can't offer a newer PG.
I tried to pg_dump a plain-text backup an run it through 8.1.8's psql.
That failed because of syntax errors.
Same with compressed backup even when I let my local 8.2.4 pg_dump send
the data to the remote server.

How would I get the stuff transfered?

By the way ... my local database is UTF-8 and the PG of Debian Sarge is
LATIN9

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Raimon Fernandez 2007-05-20 18:43:13 Re: return modified data from a function
Previous Message Tom Lane 2007-05-19 17:32:35 Re: problem - group by