upgrade 6.1 -> 6.4

From: Max Valianskiy <maxcom(at)vinchi(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: upgrade 6.1 -> 6.4
Date: 1998-11-18 19:07:34
Message-ID: 36531AF6.6E8E4438@vinchi.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)vinchi(dot)ru(dot)no-spam
Max // maxc0m http://www.linux.org.ru

Browse pgsql-admin by date

  From Date Subject
Next Message Matthew Hixson 1998-11-19 09:20:11 performance comparisons...
Previous Message Herouth Maoz 1998-11-17 16:09:20 Regression problem