Re: problem with upgrading 7.2 -> 7.3.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)es>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with upgrading 7.2 -> 7.3.4
Date: 2003-08-26 21:48:06
Message-ID: 17204.1061934486@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)es> writes:
> ./psql -d template1 -f dumpall.backup.26-08-2003
> I obtain the messages:
> ----------------
> You are now conected to database template1
> DELETE 3
> CREATE USER
> ...
> CREATE GROUP
> ERROR: user "javier"does not exist
> ALTER GROUP
> ...
> \connect: FATAL user "javier" does not exist

My guess is that "javier" was the Postgres user in the old database
(and therefore wasn't dumped by pg_dumpall) but you used some other
name for the Postgres user in the new database.

If that's not it, would you show us the initial portion of the dump
file? Looking at the create user and create group commands it issues
might help.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2003-08-26 22:05:53 Re: Buglist
Previous Message Jacob Hanson 2003-08-26 20:57:29 Re: 7.4b1 vs 7.3.4 performance