Pg dump improvements

From PostgreSQL wiki

Revision as of 15:15, 12 November 2013 by Rafaelma (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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 pgsql-hackers@postgresql.org and this page attempts to summarize what has been discussed.


.....

Personal tools