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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
