Pg dump improvements
From PostgreSQL wiki
Pg_dump improvements proposal
Currently only pg_dumpall emits database and roles attributes, such as CREATE ROLE, ALTER ROLE, ALTER DATABASE SET and ALTER ROLE SET commands.
We would like to have a pg_dump solution that can generate in one step all the necessary pieces of information needed when restoring or cloning a database (schema, data, privileges, users and alter database/role data). A discussion and a proposal has been done via firstname.lastname@example.org and this page attempts to summarize what has been discussed.