Horton

Re: Backing up multiple databases

Raymond O'Donnell <rod@iol.ie>

View thread View on postgr.es
From: "Raymond O'Donnell" <rod@iol.ie>
To: Jacob Atzen <jaa@interflow.dk>, pgsql-general@postgresql.org
Date: 2005-06-17T12:13:16Z
Lists: 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
-------------------------------------------------------------