Re: Backing up multiple databases

From: "Raymond O'Donnell" <rod(at)iol(dot)ie>
To: Jacob Atzen <jaa(at)interflow(dot)dk>, pgsql-general(at)postgresql(dot)org
Subject: Re: Backing up multiple databases
Date: 2005-06-17 12:13:16
Message-ID: 42B2CC6C.24477.6E9033@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)iol(dot)ie Galway Cathedral Recitals
-------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jacob Atzen 2005-06-17 12:18:45 Re: Backing up multiple databases
Previous Message Matthew T. O'Connor 2005-06-17 12:11:50 Re: Autovacuum in the backend