Re: Backing up multiple databases

Martha Stewart called it a Good Thing when jaa(at)interflow(dot)dk (Jacob Atzen) wrote:
> 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.

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.
--
(format nil "~S(at)~S" "cbbrowne" "cbbrowne.com")
http://linuxfinances.info/info/slony.html
TTY Message from The-XGP at MIT-AI:
The-XGP(at)AI 02/59/69 02:59:69
Your XGP output is startling.