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
Attachment:
smime.p7s
Description: S/MIME Cryptographic Signature
