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