Re: using vacuumdb in crontab

From: Cris Carampa <cris119(at)operamail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: using vacuumdb in crontab
Date: 2003-11-18 07:57:07
Message-ID: bpcjgp$mmd$1@panco.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Cris Carampa wrote:

> Sorry if this is a naive question. I'm using postgresql 7.2 on Linux
> with password authentication. I wish to issue a vaccumdb command every
> night via crontab. The problem is that vacuumdb always prompts for a
> password. How can I pass the password to vacuumdb without having to
> manually type it?

Sorry. Problem solved.

export PGPASSWORD=<passwd>

Kind regards,

--
Cris Carampa (spamto:cris119(at)operamail(dot)com)

"Poveri fanatici comunisti, noglobal e affetti dalla sindrome
anti-microsoft" (gli utenti Linux secondo un poster di ICOD)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rafael Martinez Guerrero 2003-11-18 14:01:15 Point-in-time data recovery - v.7.4
Previous Message ow 2003-11-18 05:53:07 Re: pg_restore and FK constraints with large dbs