Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group