Importing Data into an Old Version of Postgres

From: "Scott W(dot) Hill" <stmpjmpr(at)stmpjmpr(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Importing Data into an Old Version of Postgres
Date: 2003-05-05 19:52:52
Message-ID: 1052164372.3eb6c114bf7c0@www.kattare.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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-admin by date

  From Date Subject
Next Message Sidar Lopez Cruz 2003-05-06 00:51:44 News in 7.4
Previous Message Stephan Szabo 2003-05-05 17:37:41 Re: Zero length delimited identifier