One question about VACUUMDB command - please

Dear Sirs,
I'm trying to put some scipt into scheduler on my server 2000 to make auto
vacuum one time in mouth.
Why this comand that I write belove ask me for password, even I create user
into DB with same password like user on my server that execute this
command?

Can you suggest me some other solutions?

C:\>vacuumdb --host=127.0.0.1 --full --dbname=postgres

Thanks,
Best Regards,
Sasa Petrovic
Sistemi Informativi
Falc East - Knjazevac
----------------------------------------------------------------------
Il contenuto di questo messaggio è strettamente riservato e ad uso
esclusivo del destinatario previsto dal mittente. E' proibito ogni utilizzo
non autorizzato. Se ricevete questo messaggio senza esserne il
destinatario, Vi preghiamo di notificarlo al mittente via e-mail e di
distruggere il messaggio.

This e-mail is for the sole use of the intended recipient(s) and may
contain confidential information. Any unauthorised use is forbidden. If you
are not the intended recipient, please contact the sender by e-mail and
destroy the message.
----------------------------------------------------------------------

On 26-01-2012 05:31, Sasa(dot)Petrovic(at)falc(dot)biz wrote:
> Why this comand that I write belove ask me for password, even I create user
> into DB with same password like user on my server that execute this command?
>
PostgreSQL doesn't inherit authentication properties from operational system.
Instead you could use environment variables [1], pgpass.conf file [2] or even
tune pg_hba.conf [3] to not ask the password for certain host/user/database.

[1] http://www.postgresql.org/docs/current/static/libpq-envars.html
[2] http://www.postgresql.org/docs/current/static/libpq-pgpass.html
[3] http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html

--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento