> <[EMAIL PROTECTED]> writes: > > I HAVE used pg_dumpall -g to make a backup of of users and groups, but > > this output does not include the ALTER DATABASE commands.
Another related problem. pg_dump/pg_restore doesn't properly restore GRANT CREATE ON DATABASE pg_restore --create db.dump: --Sample-- [...] CREATE DATABASE db WITH TEMPLATE = template0 ENCODING = 8; \connect db pgsql \connect - dnsadm -- -- TOC entry 4 (OID 20645) -- Name: dns; Type: SCHEMA; Schema: -; Owner: dnsadm -- Data Pos: 0 -- CREATE SCHEMA dns; --End sample-- Output: psql template1 -f /tmp/x CREATE DATABASE You are now connected to database db as user pgsql. You are now connected as new user dnsadm. psql:/tmp/x:13: ERROR: db: permission denied Regards. Fernando. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
