Hello,
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?
Thanks
Andreas