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 >$DATABASEand on version 7.4.2 I want to import via:
bzcat $DATABASE | psql NEWDATABASEThe 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 >$DATABASEand 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