scripting vacuum - Mailing list pgsql-novice

From Andrew Kelly
Subject scripting vacuum
Date
Msg-id 1083755801.4133.87.camel@hermes.at.home
Whole thread Raw
Responses Re: scripting vacuum
List pgsql-novice
This seems pretty clear, but I wanted to ask in case I'm missing
something.

Given a pg_hba.conf with the single entry of
    local    all    md5
and the desire to call vacuumdb via cron,

is my only hope of success to use 'expect', or is there a way
pass the pw as an arg to vacuumdb? Or is there maybe a way to identify
specific local users like you can with hosts?
You know, something like
    local:username        all    trust
    local:allotherusers    all    md5

I've aways thought of 'expect' as rather cheesy and would love to
avoid it.

TIA

Andy


pgsql-novice by date:

Previous
From: "M. Bastin"
Date:
Subject: How to set up an SSL test environment?
Next
From: Tom Lane
Date:
Subject: Re: scripting vacuum