Hi all,
I am running PostgreSQL on Solaris 8. I have about 15 db's that I need to dump regularly but I'm having problems with pg_dumpall. Using command:
pg_dumpall -U user > dumpfile
I get this in my dumpfile:
--
-- pg_dumpall (7.2.1) -U user
--
\connect template1
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0');
and this on screen:
connected to template1...
ERROR: pg_shadow: Permission denied.
ERROR: pg_shadow: Permission denied.
I don't have a pg_shadow!!!
Also if I do manage to get pg_dumpall to work - does it leave the current database structure in place with users and databases unchanged? ------------------------------------------
Thanx | your welcome !!
roycrom
I am running PostgreSQL on Solaris 8. I have about 15 db's that I need to dump regularly but I'm having problems with pg_dumpall. Using command:
pg_dumpall -U user > dumpfile
I get this in my dumpfile:
--
-- pg_dumpall (7.2.1) -U user
--
\connect template1
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0');
and this on screen:
connected to template1...
ERROR: pg_shadow: Permission denied.
ERROR: pg_shadow: Permission denied.
I don't have a pg_shadow!!!
Also if I do manage to get pg_dumpall to work - does it leave the current database structure in place with users and databases unchanged? ------------------------------------------
Thanx | your welcome !!
roycrom