The Wayback Machine - http://web.archive.org/web/20201129161736/https://github.com/dalibo/pg_dumpacl
Skip to content
master
Go to file
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
pkg
 
 

README.md

pg_dumpacl

A tool to dump ACL per database, based on pg_dump

$ ./pg_dumpacl -d db0
--
-- Database creation
--

CREATE DATABASE "db0" WITH TEMPLATE = template0 OWNER = "postgres";
REVOKE ALL ON DATABASE "db0" FROM PUBLIC;
REVOKE ALL ON DATABASE "db0" FROM "postgres";
GRANT ALL ON DATABASE "db0" TO "postgres";
GRANT CONNECT,TEMPORARY ON DATABASE "db0" TO PUBLIC;
GRANT CONNECT ON DATABASE "db0" TO "dba";

Packaging

Use make rpms to build RPM packages for PostgreSQL version that require it. As of 2020Q4, supported versions that require pg_dumpacl are 9.5, 9.6 and 10.

Define DIST to centos7 or centos8, to build RPM packages for CentOS/RHEL 7 or 8, 7 being the default.

Installation

Enable Dalibo Labs YUM repository and install pg_dumpacl10 package or the variant for the version of Postgres installed.

# yum install -y https://yum.dalibo.org/labs/dalibo-labs-1-1.noarch.rpm
# yum makecache fast
# yum search pg_dumpacl
=================== N/S matched: pg_dumpacl ================================
pg_dumpacl10.x86_64 : Tool for dumping database creation options
pg_dumpacl93.x86_64 : Tool for dumping database creation options
pg_dumpacl94.x86_64 : Tool for dumping database creation options
pg_dumpacl95.x86_64 : Tool for dumping database creation options
pg_dumpacl96.x86_64 : Tool for dumping database creation options
#
You can’t perform that action at this time.