Recommended way to dump multi db cluster - Mailing list pgsql-admin

From lst_hoe02@kwsoft.de
Subject Recommended way to dump multi db cluster
Date
Msg-id 20130808105619.Horde.7kxU4Ktcgakk9mE61CvHKw4@webmail.kwsoft.de
Whole thread Raw
Responses Re: Recommended way to dump multi db cluster  (Jan Lentfer <Jan.Lentfer@web.de>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Brian Wong
Date:
Subject: Re: After upgrading from 9.1.1 to 9.1.9, pgadmin's server status window gives error
Next
From: Jan Lentfer
Date:
Subject: Re: Recommended way to dump multi db cluster