On Fri, Jun 17, 2005 at 08:43:21AM -0400, Christopher Browne wrote: > >> There is an option to pg_dumpall, -O, which makes it dump stuff > >> without owners. See the following:
> > 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. > That option did exist in 7.4, so you're not being steered terribly > wrongly, although you may want to check the docs from v7.4 in case > there are any other differences relevant to you. It doesn't exist in pg_dumpall on 7.4.5: % pg_dumpall -O pg_dumpall: invalid option -- O But I'll just use pg_dump where it does exist. -- Thanks, Jacob Atzen ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
