Importing Data into an Old Version of Postgres - Mailing list pgsql-general

From Scott W. Hill
Subject Importing Data into an Old Version of Postgres
Date
Msg-id 1052184348.3eb70f1c715db@www.kattare.com
Whole thread Raw
List pgsql-general
Sorry to cross-post, but the Admin list doesn't appear to be very active...

I'm switching service providers, and going from a 7.3.2 database to 7.2.3.
I've done a pg_dump of my database, and much of my data has embedded
newlines (represented as '/n' in the dump file). These seem to be causing
many errors during the import (using psql) into the older database,
although the same dump can be imported into another 7.3.x database.

I understand that the dump data formats change between major releases, and
am wondering if there's a workaround that someone knows that can facilitate
my needs. I've looked in the archives, and only found problems related to
Windows linefeed munging, which isn't the case here since there is no
Windows step in my workflow.

TIA,

--Scott



pgsql-general by date:

Previous
From: Jason Hihn
Date:
Subject: Many little databases or one big one?
Next
From: Bruno Wolff III
Date:
Subject: Re: Many little databases or one big one?