upgrade path / versioning roles - Mailing list pgsql-hackers

From Patrick Welche
Subject upgrade path / versioning roles
Date
Msg-id 20050901164134.GG6553@quartz.itdept.newn.cam.ac.uk
Whole thread Raw
Responses Re: upgrade path / versioning roles
List 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)
asrolname, nspacl FROM pg_namespace
 


Cheers,

Patrick


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: TODO item: set proper permissions on non-system schemas
Next
From: Josh Berkus
Date:
Subject: Re: Remove xmin and cmin from frozen tuples