On 2/8/06 17:38, "Chuck" <[EMAIL PROTECTED]> wrote:
> After running pgAgent with the following command:
>
> /usr/bin/pgagent -l 2 hostaddr=127.0.0.1 dbname=postgres user=postgres
>
> The pertinent debug message said:
>
> WARNING: Couldn't create connection: fe_sendauth: no password supplied
After running pgAgent with the following command:
/usr/bin/pgagent -l 2 hostaddr=127.0.0.1 dbname=postgres user=postgres
The pertinent debug message said:
WARNING: Couldn't create connection: fe_sendauth: no password supplied
Why do I need a password for the postgres account when on the local
m
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Chuck
> Sent: 02 August 2006 16:13
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] pgAgent - Log error when running
>
> The job is only a simple
The job is only a simple insert command for test purposes. It takes
milliseconds to run so the the timing issue is still a question.
I have given the postgres account full access to everything. I checked
the ph_hba.conf and there is a line for the postgres account as
follows:
local all postgres i
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Chuck
> Sent: 02 August 2006 13:19
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] pgAgent - Log error when running
>
> Yes, it was a typo in the messa
Yes, it was a typo in the message but I entered and ran the command
correctly.
Some new information. I ran the command again but used a superuser
account and added password= to the command line. My test script is
being run by pgAgent every two minutes. It shoud be running every
minute.
I know
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Chuck
> Sent: 02 August 2006 12:49
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] pgAgent - Log error when running
>
> I assume you are thinking th
I assume you are thinking there is a space in the IP address. There is
not a typo in the command line that I can see.
I have enabled connection logging and this is what I now find in the
log.
Notice the port number keeps increasing by one each time. I have run
both the pgAgent startup commands so
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Chuck
> Sent: 02 August 2006 02:29
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] pgAgent - Log error when running
>
> I am running pgAgent on Debian Sar
I am running pgAgent on Debian Sarge with postgresql 8.1.4. I have run
the SQLscript and installed the tables. I have run the daemon with the
command:
/usr/bin/pgagent hostaddr=127.0.0.1 dbname=postgres user postgres
I have also tried the command:
/usr/bin/pgagent hostaddr=127.0.0.1 dbna
10 matches
Mail list logo
