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
