Thread: using vacuumdb in crontab

using vacuumdb in crontab

From
Cris Carampa
Date:
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?

Kind regards,

--
Cris Carampa (spamto:cris119@operamail.com)

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


Re: using vacuumdb in crontab

From
Raquel Vieira
Date:
I'm using the command vaccumdb like this:

su - postgres -c "vacuumdb AgenteSIP"

I don't need to introduce the password for postgres.

I think thos is all you need.

Raquel Vieira



On Monday 17 November 2003 10:53 am, 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?
>
> Kind regards,