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
#