Upgrading from 7.1.3 to 7.2.3

From: Jodie <starky(at)shreve(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Upgrading from 7.1.3 to 7.2.3
Date: 2003-08-07 20:53:36
Message-ID: 1060289615.6039.151.camel@starky
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-08-07 20:59:22 Re: Performance
Previous Message Iande 2003-08-07 20:49:14 Re: Function and Tables Privilege