Help with upgrading old 6.1 installation on Irix5
От | Alex Shnitman |
---|---|
Тема | Help with upgrading old 6.1 installation on Irix5 |
Дата | |
Msg-id | 14203.57066.870840.965784@hectic.hectic.net обсуждение исходный текст |
Список | pgsql-general |
Hi All my attempts have been in vain so far so I come to seek your advice. I have an old PostgreSQL 6.1 installation on an Irix 5 machine that I want to upgrade to 6.5. The issue is dumping the old database. Here's what I've tried so far (I tried all these things both on the original installation and a freshly compiled 6.1.1 with a copy of the data directory; the results are the same): * Tried to dump with the supplied 6.1[.1] pg_dump program. It starts dumping and after a few lines it gets a bus error. Perhaps it's because the Irix5 port wasn't very good then? * Instaled 6.2.1 and tried to use its pg_dump program. I get the following error message on the *server* (postmaster) stdout (or stderr): "WARN:attribute "relchecks" not found", for any database I'm trying to dump. I ran pg_dump with -v to see where that happens and got this: -- last builtin oid is 17280 -- reading user-defined types -- reading user-defined functions -- reading user-defined aggregates -- reading user-defined operators -- reading user-defined tables getTables(): SELECT failed > It's interesting that with the original 6.1 (and not my compiled) pg_dump simply hang indefinitely instead of this. I don't think that helps though. * Installed both 6.4.2 and 6.5 and tried using their respective pg_dump programs. In both cases what happens is this error message: Failed to authenticate client as Postgres user 'john' using <unknown authentication type>: be_recvauth: unrecognized message type: 131072 (Of course I ran pg_dump with -h localhost so it uses inet sockets.) Does anyone have any suggestions what to do with it? Thanks a lot in advance for anything you come up with! Regards, --Alex -- Alex Shnitman | http://www.debian.org alexsh@hectic.net, alexsh@linux.org.il +----------------------- http://alexsh.hectic.net UIN 188956 PGP key on web page E1 F2 7B 6C A0 31 80 28 63 B8 02 BA 65 C7 8B BA
В списке pgsql-general по дате отправления: