Thread: probelm migrating from 7.3.4 to 7.42

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

This worked for varrious version the last years but now it seems as if
the byteorder is changed. The above command fails.

I assume, in case I did nothing false, that this must be a known problem
and hope that there is a solution??

Thanks a lot
Michael


--
Encrypted eMail welcome!
Get my OpenPGP-Key ID: 0xE9B00731 from: wwwkeys.de.pgp.net

MichaelHoeller@t-online.de (Michael Hoeller) writes:
> This worked for varrious version the last years but now it seems as if
> the byteorder is changed. The above command fails.

You're going to have to offer some actual details if you want useful
help.  "Fails" how, exactly?

            regards, tom lane

В Птн, 06.08.2004, в 23:12, Michael Hoeller пишет:

> 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
>
> The above command fails.

You need to be quite a bit more specific than that :)

--
Markus Bertheau <twanger@bluetwanger.de>

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