On Thu, 08 Aug 2013 10:56:19 +0200, lst_hoe02@xxxxxxxxx wrote:
as of now we do a pg_dumpall on most of our PostgreSQL instances. This has some drawbacks when restore of only one of the databases is required, because from what i can see pg_restore is not able to limit the restore to one database? With pg_dump per database the problem will arise to backup user/roles and other central settings, so what is the recommended way to dump multi database instances?
use pg_dumpall for globals only (there is a command line switch for that) und use pg_dump (I use custom format, because it gives me most flexibility
when restoring) for databases. Regards, Jan -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
