Trouble upgrading old 6.1 install on Irix5 - Mailing list pgsql-general

From Alex Shnitman
Subject Trouble upgrading old 6.1 install on Irix5
Date
Msg-id 14203.58317.595118.530180@hectic.hectic.net
Whole thread Raw
List 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

Minds are like parachutes... they work best when open.

pgsql-general by date:

Previous
From: Alex Shnitman
Date:
Subject: Help with upgrading old 6.1 installation on Irix5
Next
From: Travis
Date:
Subject: ...