Re: Re: vacuum and backup

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
Cc: Mitch Vincent <mitch(at)venux(dot)net>, "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com>, Doug McNaught <doug(at)wireboard(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: vacuum and backup
Date: 2001-02-28 13:29:05
Message-ID: 3A9CFD21.95B8421@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lincoln Yeoh wrote:
>
> At 01:52 PM 27-02-2001 -0500, Mitch Vincent wrote:
> >
> >I agree 100% that a shell script is probably the best way to go.. All you're
> >doing is running a few utilities, there is hardly any processing on the part
> >of the script that calls the utilities so there isn't much of a need for
> >anything more than what sh (or what ever you like) has to offer..
> >
>
> How would I automate backup if I use password authentication?

We solve that problem here by running the backup under the
postgres user, which has superuser priveledges.

Other than that I'm not sure what can be done...
--
Occam's Principle of Limited Imagination
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2001-02-28 13:54:45 strange error
Previous Message Renaud Tthonnart 2001-02-28 13:26:12 Re: array containing references