> <btober@seaworthysys.com> 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.
