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

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(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:17:42
Message-ID: Pine.LNX.4.33.0305071316500.9473-100000@css120.ihs.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! :)

Is this all happening on the same basic platform, or are you running
windows and Unix mixed? It might be easiest to just use awk or sed to
strip out the newlines.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-05-07 19:18:35 Re: Creating functions and triggers
Previous Message Stephan Szabo 2003-05-07 19:11:56 Re: indices - used by which user ?