Re: Backing up multiple databases
Jacob Atzen <jaa@interflow.dk>
From: Jacob Atzen <jaa@interflow.dk>
To: pgsql-general@postgresql.org
Date: 2005-06-17T12:18:45Z
Lists: 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