Re: Restoring 7.3.x Data on 7.2.x Database

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Scott W(dot) Hill" <stmpjmpr(at)stmpjmpr(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restoring 7.3.x Data on 7.2.x Database
Date: 2003-05-07 19:28:39
Message-ID: 20030507122625.A29802-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2003-05-07 19:37:30 Re: How to hook up Access to Postgres?
Previous Message Richard Huxton 2003-05-07 19:18:35 Re: Creating functions and triggers