upgrade 6.1 -> 6.4 - Mailing list pgsql-admin

From Max Valianskiy
Subject upgrade 6.1 -> 6.4
Date
Msg-id 36531AF6.6E8E4438@vinchi.ru
Whole thread Raw
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Herouth Maoz
Date:
Subject: Regression problem
Next
From: Matthew Hixson
Date:
Subject: performance comparisons...