From: | David J N Begley <d(dot)begley(at)uws(dot)edu(dot)au> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #2085: pg_dump incompletely dumps ACLs |
Date: | 2005-12-02 05:53:31 |
Message-ID: | Pine.LNX.4.61.0512021635540.12379@viper.uws.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Earlier today, Tom Lane wrote:
> "David Begley" <d(dot)begley(at)uws(dot)edu(dot)au> writes:
> > This means when the dump is imported to another PostgreSQL instance, the
> > resultant ACLs do not match those of the original instance.
>
> Please provide a concrete test case, not handwaving.
C:\Program Files\PostgreSQL\8.1\bin>createdb concrete "Test Case"
CREATE DATABASE
COMMENT
C:\Program Files\PostgreSQL\8.1\bin>psql -q concrete
concrete=# REVOKE ALL ON DATABASE concrete FROM PUBLIC;
concrete=# REVOKE ALL ON DATABASE concrete FROM david;
concrete=# SELECT datacl FROM pg_database WHERE datname = 'concrete';
datacl
--------
{}
(1 row)
concrete=# \q
C:\Program Files\PostgreSQL\8.1\bin>pg_dump -C -f \windows\temp\dump.sql concrete
C:\Program Files\PostgreSQL\8.1\bin>dropdb -q concrete
C:\Program Files\PostgreSQL\8.1\bin>psql -f \windows\temp\dump.sql postgres
SET
SET
SET
CREATE DATABASE
ALTER DATABASE
You are now connected to database "concrete".
SET
SET
SET
COMMENT
COMMENT
CREATE LANGUAGE
REVOKE
REVOKE
GRANT
GRANT
C:\Program Files\PostgreSQL\8.1\bin>psql -q concrete
concrete=# SELECT datacl FROM pg_database WHERE datname = 'concrete';
datacl
--------
(1 row)
concrete=# -- datacl in restored database does not match origin database
concrete=# \q
From | Date | Subject | |
---|---|---|---|
Next Message | Weiss, Wilfried | 2005-12-02 07:53:14 | Re: BUG #2083: initdb fails with: child process was terminated by signal 11 |
Previous Message | Tom Lane | 2005-12-02 05:31:28 | Re: BUG #2085: pg_dump incompletely dumps ACLs |