470,614 Members | 1,396 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

problem with upgrading 7.2 -> 7.3.4

Hello;

With your help I've got a recently installed postgres7.3.4 version. But when
I try to upgrade my data I have an error.
I've spent a couple of hour trying to solve it with no result, and perhaps
you can help.

I've got two different computer one with the 7.2 and the other with 7.3.4
version.
I've made the dump_all with no problem. But when I type, in the new psql:

../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
-------------------
I've also tried (seen in Administrator guide 9.3):
../psql template1 < dumpall.backup.26-08-2003
what I guess is the same. Because I obtain the same messages.

And I obtain the messages no matter if the groups or user "javier" (me)
existed previously in the new postgres cluster (I've tried to CREATE, DROP,
re-CREATE... "javier" before bringing the dumped file with the same result).

Can you give me any clue?

Thanks,

Javier

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 11 '05 #1
1 1259
javier garcia - CEBAS <rn***@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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by starman | last post: by
6 posts views Thread by John Morgan | last post: by
5 posts views Thread by Mike Owen | last post: by
4 posts views Thread by james | last post: by
1 post views Thread by progTiger | last post: by
9 posts views Thread by Marshall Dudley | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.