Thread: upgrade 6.1 -> 6.4

Hello!

    I have a problem with upgrade PostgreSQL from version 6.1 to
6.4. I seems that problem is that 6.1 uses pg_user and 6.4 pg_shadow
to store user accounts. So pg_dumpall from 6.4 fails on my databases:

[postgres@da pg_dump]$ ./pg_dumpall -z > db.out
WARN:pg_shadow: Table does not exist.
WARN:COPY command failed.  Class tmp_pg_shadow does not exist.
WARN:Relation tmp_pg_shadow Does Not Exist!
....

So how can I upgrade it?

--
Best wishes,                  maxcom@vinchi.ru.no-spam
Max // maxc0m                 http://www.linux.org.ru