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
#