> On Thu, 08 Aug 2013 10:56:19 +0200, lst_hoe02@kwsoft.de 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