pgAgent on Windows

From: "Josi Perez (3T Systems)" <josiperez3t(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pgAgent on Windows
Date: 2010-09-01 20:27:33
Message-ID: AANLkTimHghBoDufTLo6OkhNQHcmJ_yGgvg+Hi01Ha0nL@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I can't to put the pgAgent service using parameter postgres to (Windows
username) and (database username) without to use the password parameter
inside the connection string (hostaddr=127.0.0.1 dbname=postgres
user=postgres password=ourPassword).

If I put Windows user and postgres to database user, no problem: the
pgpass.conf is read.
But, if I use (-u postgres) as a Windows user too (like the postgreSQL
service), I think that pgAgent does not read the pgpass.conf. I tried to use
the variable PGPASSFILE without success.

Any sugestions?
Thank you,
Josi Perez

Browse pgsql-admin by date

  From Date Subject
Next Message Ireneusz Pluta 2010-09-01 21:18:45 Invalid page header
Previous Message Kong Mansatiansin 2010-09-01 19:49:51 Query Optimization with Partitioned Tables