From: | Együd Csaba (Freemail) <csegyud(at)freemail(dot)hu> |
---|---|
To: | Pgadmin-Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | pgAgent authentication problem |
Date: | 2006-11-30 15:30:59 |
Message-ID: | 001301c71494$89807140$060a0a0a@ACER |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
[Sorry if this post arrives twice. I have problems with my news reader.]
Hi ,
I installed pgAdmin3 1.6 on WindowsXP SP2. The postgres 8.1.4 server is
running on localhost (port=54814).
I try to test pgAgent before I switch it to production.
I realized that everithing works well when I put a password="xxx" into the
connection string during service INSTALL.
INSTALL command:
pgagent INSTALL PgAgent -u postgres -p ABCD -l 2 hostaddr=127.0.0.1
dbname=postgres user=postgres password="ZZZZZ" port=54814
BUT
When I try to use pgpass.conf the service reports this: "Couldn't create
connection: fe_sendauth: no password supplied".
(My pgpass.conf is in "C:\Documents and Settings\Csaba\Application
Data\postgresql" folder.)
it's contents:
-------------------------------------------
localhost:54814:*:postgres:ZZZZZ
localhost:54814:*:Csaba:XXXXXX
-------------------------------------------
INSTALL comand:
pgagent INSTALL PgAgent -u postgres -p ABCD -l 2 hostaddr=127.0.0.1
dbname=postgres user=postgres port=54814
It seems pgagent is not able to find pgpass.conf. BTW, PgAdmin uses it
correctly.
What could be the problem? A bug or more likely a misconfiguration?
Many thanks,
-- Csaba Együd
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.2/559 - Release Date: 2006.11.30.
5:07
From | Date | Subject | |
---|---|---|---|
Next Message | Ezequias Rodrigues da Rocha | 2006-11-30 16:50:09 | Re: pgAgent authentication problem |
Previous Message | Hélder M. Vieira | 2006-11-30 15:21:51 | Re: Backup/Restore |