Re: probelm migrating from 7.3.4 to 7.42

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