Horton

upgrade path / versioning roles

Patrick Welche <prlw1@newn.cam.ac.uk>

View thread View on postgr.es
From: Patrick Welche <prlw1@newn.cam.ac.uk>
To: pgsql-hackers@postgresql.org
Date: 2005-09-01T16:41:34Z
Lists: pgsql-hackers 
I think we still recommend using *new* pg_dump to dump *old* server when
upgrading. If one tries that with today's pg_dump (8.1beta1) against 
a 8.1devel server of 6 May, i.e., predating roles, one gets:

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  relation "pg_catalog.pg_roles" does not exist
pg_dump: The command was: SELECT tableoid, oid, nspname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) as rolname, nspacl FROM pg_namespace


Cheers,

Patrick