On Tue, 20 Sep 2005, Jim C. Nasby wrote:
> On Tue, Sep 20, 2005 at 11:04:44AM -0400, Belinda M. Giardine wrote:
> > > For vacuuming, you could try to use the autovacuum daemon, it is
> > > included in the contrib part of postgres. If you installed from source,
> > > you will likely need to separ
On Tue, Sep 20, 2005 at 11:04:44AM -0400, Belinda M. Giardine wrote:
> > For vacuuming, you could try to use the autovacuum daemon, it is
> > included in the contrib part of postgres. If you installed from source,
> > you will likely need to separately install autovacuum, if you installed
> > a pre
You can set up pg_hba.conf so that only certain Unix users that have
access to the local Unix PostgreSQL socket can access the database
without a password (every other process uses a TCP/IP connection); then
move the socket location to other than /tmp and restrict its access w/
Unix controls. De
On Tue, 20 Sep 2005, John DeSoi wrote:
>
> On Sep 19, 2005, at 2:27 PM, Belinda M. Giardine wrote:
>
> > As far as I can tell vacuum must be run by the table or database
> > owner.
> > It wouldn't be as bad to have the password in the script if it was a
> > limited permissions user. Any suggest
On Tue, 20 Sep 2005, Csaba Nagy wrote:
> You could use the system wide crontab, which is configured via
> /etc/crontab, and there you can specify what user should execute the
> command, without needing passwords. The system wide crontab is executed
> as root and it will su to the user you specif
On Sep 19, 2005, at 2:27 PM, Belinda M. Giardine wrote:
As far as I can tell vacuum must be run by the table or database
owner.
It wouldn't be as bad to have the password in the script if it was a
limited permissions user. Any suggestions on the best methods?
Setup a .pgpass file so you do
You could use the system wide crontab, which is configured via
/etc/crontab, and there you can specify what user should execute the
command, without needing passwords. The system wide crontab is executed
as root and it will su to the user you specify.
For vacuuming, you could try to use the autova
This seems like it should be a frequently asked question, but I am having
trouble finding the answer. I am in the process of switching to using
Postgres, and realize that I need to run vacuum analyze regularly on the
tables. This is on a Unix system so cron is the obvious choice. The
problem is