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

From Jacob Atzen
Subject Re: Backing up multiple databases
Date
Msg-id 20050617121845.GA10944@interflow.dk
Whole thread Raw
In response to Re: Backing up multiple databases  ("Raymond O'Donnell" <rod@iol.ie>)
List pgsql-general
On Fri, Jun 17, 2005 at 01:13:16PM +0100, Raymond O'Donnell wrote:
> 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

Ah yes, I should have told you that the server is running 7.4.5, sorry.
I will consider upgrading if there's no alternative way.

--
Thanks,
Jacob Atzen

pgsql-general by date:

Previous
From: "Raymond O'Donnell"
Date:
Subject: Re: Backing up multiple databases
Next
From: Jose Gonzalez Gomez
Date:
Subject: Foreign key to a view (UNION of two or more tables), any alternative?