Re: Backing up multiple databases - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Backing up multiple databases
Date
Msg-id 42B2CC6C.24477.6E9033@localhost
Whole thread Raw
In response to Backing up multiple databases  (Jacob Atzen <jaa@interflow.dk>)
Responses Re: Backing up multiple databases
List pgsql-general
On 17 Jun 2005 at 13:52, Jacob Atzen wrote:

> The second problem is a matter of database ownership. Apparently
> pg_dumpall will dump the owners of the database along with the data.
> This is causing trouble when I try to restore the dump on a server where

There is an option to pg_dumpall, -O, which makes it dump stuff
without owners. See the following:

  http://www.postgresql.org/docs/8.0/static/app-pg-dumpall.html

--Ray O'Donnell

-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------


pgsql-general by date:

Previous
From: Jacob Atzen
Date:
Subject: Backing up multiple databases
Next
From: Jacob Atzen
Date:
Subject: Re: Backing up multiple databases