Re: Backing up multiple databases

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