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