Postgres Pro
Downloads
Home   >   mailing lists

Re: probelm migrating from 7.3.4 to 7.42 - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: probelm migrating from 7.3.4 to 7.42
Date
Msg-id 41140FBB.3090809@bigfoot.com
Whole thread Raw
In response to probelm migrating from 7.3.4 to 7.42  (MichaelHoeller@t-online.de (Michael Hoeller))
List pgsql-general
Tree view 
Michael Hoeller wrote:

> Hello,
>
> I searched the archives and since I'm a relatively noivce user I'll have
> to run the risk of repeating already asked questions.
>
> I'm having a problem to migrate from version 7.3.4 to 7.4.2
>
> On version 7.3.4 I do:
> vacuumdb --analyze $PGDATABASE
> pg_dump -x $PGDATABASE >$DATABASE
>
> and on version 7.4.2 I want to import via:
> bzcat $DATABASE  | psql NEWDATABASE

Why do you use a bzcat command with an ascii file ?

Try with this:

psql -f $DATABASE NEWDATABASE




Regards
Gaetano Mendola

pgsql-general by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Postgres and Tools Intro?
Next
From: Jerry LeVan
Date:
Subject: Re: Lost my blobs and can't restore.