Importing Data into an Old Version of Postgres

From: "Scott W(dot) Hill" <stmpjmpr(at)stmpjmpr(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Importing Data into an Old Version of Postgres
Date: 2003-05-06 01:25:48
Message-ID: 1052184348.3eb70f1c715db@www.kattare.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-05-06 01:31:27 Re: Many little databases or one big one?
Previous Message Jason Hihn 2003-05-05 20:04:24 Many little databases or one big one?