Re: Restoring 7.3.x Data on 7.2.x Database - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Restoring 7.3.x Data on 7.2.x Database
Date
Msg-id 20030507122625.A29802-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Restoring 7.3.x Data on 7.2.x Database  ("Scott W. Hill" <stmpjmpr@stmpjmpr.com>)
Responses Re: Restoring 7.3.x Data on 7.2.x Database  ("Scott W. Hill" <stmpjmpr@stmpjmpr.com>)
List pgsql-general
On Wed, 7 May 2003, Scott W. Hill wrote:

> I'm having trouble getting my data, which does have embedded newlines, to
> go from a 7.3.2 PostgreSQL setup to a 7.2.3. I'm using a service provider's
> database, so upgrading on my timeline isn't an option. The embedded
> newlines seem to choke the restore process on 7.2.x, although restoring the
> same data to another 7.3.2 database is no problem. Help! :)

How are you doing the dumps?  You might want to try with -d (or -D) to get
insert statements rather than copy.  It's (alot) slower on restore, but it
might handle the restore better.


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Restoring 7.3.x Data on 7.2.x Database
Next
From: Jeff Eckermann
Date:
Subject: Re: How to hook up Access to Postgres?