| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-04-30 16:19:30 | Re: Unable to drop index |
| Previous Message | Mauri Sahlberg | 2005-04-30 08:16:59 | Backing up users? |