pg_dump/all doesn't output database ACLs (v7.3.4)

From: Ben Grimm <ben(at)zaeon(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_dump/all doesn't output database ACLs (v7.3.4)
Date: 2003-09-04 12:38:52
Message-ID: 20030904123852.GA6105@zaeon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I haven't tried the 7.4 beta, so it may be fixed there - but in
7.3.4, pg_dumpall doesn't output global database ACL's. Try this
in a fresh database after an initdb:

template1=# create user test nocreatedb nocreateuser;
CREATE USER
template1=# create database testdb;
CREATE DATABASE
template1=# grant create on database testdb to test;
GRANT
template1=# select datname, datacl from pg_database ;
datname | datacl
-----------+-------------------------
testdb | {=T,postgres=CT,test=C}
template1 | {=,postgres=CT}
template0 | {=,postgres=CT}
(3 rows)
template1=# \q

$ pg_dumpall -U postgres
--
-- PostgreSQL database cluster dump
--

\connect "template1"

--
-- Users
--

DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0');

CREATE USER test WITH SYSID 100 NOCREATEDB NOCREATEUSER;

--
-- Groups
--

DELETE FROM pg_group;

--
-- Database creation
--

CREATE DATABASE testdb WITH OWNER = postgres TEMPLATE = template0 ENCODING = 'SQL_ASCII';

\connect template1
--
-- PostgreSQL database dump
--

--
-- TOC entry 2 (OID 1)
-- Name: DATABASE template1; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON DATABASE template1 IS 'Default template database';

\connect testdb
--
-- PostgreSQL database dump
--

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ben Grimm 2003-09-04 12:59:37 pg_dump/all doesn't output schemas correctly (v7.3.4)
Previous Message Martin Edlman 2003-09-04 07:54:42 Foreign key not working in some cases when using triggers