I tried using pg_dumpall and got this error: pg_dumpall: query failed: ERROR: permission denied for relation pg_shadow pg_dumpall: query was: SELECT usename, usesysid, passwd, usecreatedb, usesuper, valuntil, (usesysid = (SELECT datdba FROM pg_database WHERE datname = 'template0')) AS clusterowner FROM pg_shadow
I haven't messed around with template0. This is a recent installation of postgres (8.0.x), done via yum. Any idea what the problem is and how to fix it? thanks, CSN __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
