Re: Backing up users? - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Backing up users?
Date
Msg-id 20050430121812.GA15615@wolff.to
Whole thread Raw
In response to Backing up users?  (Mauri Sahlberg <Mauri.Sahlberg@claymountain.com>)
List pgsql-admin
On Sat, Apr 30, 2005 at 11:16:59 +0300,
  Mauri Sahlberg <Mauri.Sahlberg@claymountain.com> wrote:
> Hi,
>
> This might be a stupid question as it is not covered in the 7.4.7 and
> probably obvious to all others. Where do the system catalogs live? How
> to back them up? Should I back them up?
>
> The admin manual states that to restore a pg_dumped database you should
> have those users created that will have permission related to objects
> created by pg_restore but gives no clear instructions how to back the
> users up and how to restore them before restoring the database.

You want to use pg_dumpall.

pgsql-admin by date:

Previous
From: Mauri Sahlberg
Date:
Subject: Backing up users?
Next
From: Tom Lane
Date:
Subject: Re: Unable to drop index