Skip site navigation (1) Skip section navigation (2)

Re: Backing up users?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Mauri Sahlberg <Mauri(dot)Sahlberg(at)claymountain(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backing up users?
Date: 2005-04-30 12:18:12
Message-ID: 20050430121812.GA15615@wolff.to (view raw or flat)
Thread:
Lists: pgsql-admin
On Sat, Apr 30, 2005 at 11:16:59 +0300,
  Mauri Sahlberg <Mauri(dot)Sahlberg(at)claymountain(dot)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.

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2005-04-30 16:19:30
Subject: Re: Unable to drop index
Previous:From: Mauri SahlbergDate: 2005-04-30 08:16:59
Subject: Backing up users?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group