javier garcia - CEBAS <rn001@cebas.csic.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
