From: | acoutinho(at)csu(dot)com(dot)br |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | RES: using vacuumdb in crontab |
Date: | 2003-11-19 12:02:44 |
Message-ID: | 31A2FFCFAF95D51189790002A57568FA0DEDE4B5@csusppro12.csu.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
You can alter yuor pg_hba.conf to permit "trust" local connections
instead of "md5". This authentication you can left to external connetions.
Thi way a think you will execute de vacummdb successfully.
-----Mensagem original-----
De: Raquel Vieira [mailto:raquel(dot)vieira(at)ent(dot)efacec(dot)pt]
Enviada em: Quarta-feira, 19 de Novembro de 2003 06:35
Para: pgsql-admin(at)postgresql(dot)org
Assunto: Re: [ADMIN] using vacuumdb in crontab
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,
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2003-11-19 13:32:36 | Re: Point-in-time data recovery - v.7.4 |
Previous Message | jtaaribi | 2003-11-19 11:43:29 | Re: Postgresql DB on a live cd |