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

From: "Scott W(dot) Hill" <stmpjmpr(at)stmpjmpr(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(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 20:16:32
Message-ID: 1052338592.3eb969a0572a6@www.kattare.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks! The -D option was just the trick. I wasn't able to use the other
suggestion to use sed to strip the newlines, since the newlines were valid
data in this case.

--Scott

Quoting Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>:

> 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

Browse pgsql-general by date

  From Date Subject
Next Message Jon Earle 2003-05-07 20:19:10 Re: PostgreSQL Qs
Previous Message Bruno Wolff III 2003-05-07 20:10:10 Re: PostgreSQL Qs