Thread: Upgrading from 7.1.3 to 7.2.3

I am trying to upgrade from 7.1.3-4bp.2 to 7.2.3-5.80.  I have completed
the pg_dumpall > dump_file successfully on the old server.  However, I
am having trouble inserting the information into the new server. I am
using psql -f dump_file template1.  It complains about the userid.
"user id must be positive"  The root userid is 0.  Has this changed from
version to version?  Also, it later complains of an authentication
failure for one of the other users.  When I ran psql if db.out
template1, it seems to have only complained about the userid for root,
so it looks like this second user was created.  Perhaps this problem is
being caused by the fact that the root user could not be created.

Any help would be appreciated.

Thanks!
--
Jodie E Crouch III

Jodie <starky@shreve.net> writes:
> I am trying to upgrade from 7.1.3-4bp.2 to 7.2.3-5.80.

Uh ... 7.2.3 is ancient history.  You should *certainly* be going to
7.2.4 if you want to be in the 7.2 series, but why not 7.3.4 instead?

> I have completed
> the pg_dumpall > dump_file successfully on the old server.  However, I
> am having trouble inserting the information into the new server. I am
> using psql -f dump_file template1.  It complains about the userid.
> "user id must be positive"  The root userid is 0.  Has this changed from
> version to version?

No.  I tried "create user root with sysid 0" and got that error in all
releases back to 7.0, the oldest one I have handy.  Not sure how you
managed to get it into your previous system.  I'd recommend hand-editing
the dump file to remove the id specification.  Or you could manually
create user root (with a legal sysid) before loading the dump file,
and just ignore the error from the dump's attempt to create it.

            regards, tom lane