Thread: Where is located pgAgent log on Linux ?

Where is located pgAgent log on Linux ?

From
"Sabin Coanda"
Date:
Hi,
 
Do you know where is located pgAgent log on Linux, please ?
 
TIA,
Sabin

Re: Where is located pgAgent log on Linux ?

From
Dave Page
Date:
Sabin Coanda wrote:
> Hi,
>  
> Do you know where is located pgAgent log on Linux, please ?

stderr, or you can use the -s option to specify a file.

I noticed this is missing from the docs which I've now corrected.

Regards, Dave.


Re: Where is located pgAgent log on Linux ?

From
"Sabin Coanda"
Date:
"Dave Page" <dpage@postgresql.org> wrote in message 
news:45F7B29D.1020408@postgresql.org...
> Sabin Coanda wrote:
>> Hi,
>>  Do you know where is located pgAgent log on Linux, please ?
>
> stderr, or you can use the -s option to specify a file.
>
> I noticed this is missing from the docs which I've now corrected.
>
> Regards, Dave.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                http://www.postgresql.org/about/donate
>

Hi Dave,

I start pgagent on linux with the following command:
       pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1

It works well and send the message logs to console.
But when I wish to log to a file, and I start it with the command:
       pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1 -s 
/var/log/pgagent/pgagent.log

It logs the following error:
       Couldn't create connection: missing "=" after 
"/var/log/pgagent/pgagent.log" in connection info string

What's happen ?

Regards,
Sabin 




Re: Where is located pgAgent log on Linux ?

From
Dave Page
Date:
Sabin Coanda wrote:
> "Dave Page" <dpage@postgresql.org> wrote in message 
> news:45F7B29D.1020408@postgresql.org...
>> Sabin Coanda wrote:
>>> Hi,
>>>  Do you know where is located pgAgent log on Linux, please ?
>> stderr, or you can use the -s option to specify a file.
>>
>> I noticed this is missing from the docs which I've now corrected.
>>
>> Regards, Dave.
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 7: You can help support the PostgreSQL project by donating at
>>
>>                http://www.postgresql.org/about/donate
>>
> 
> Hi Dave,
> 
> I start pgagent on linux with the following command:
> 
>         pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1
> 
> It works well and send the message logs to console.
> But when I wish to log to a file, and I start it with the command:
> 
>         pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1 -s 
> /var/log/pgagent/pgagent.log
> 
> It logs the following error:
> 
>         Couldn't create connection: missing "=" after 
> "/var/log/pgagent/pgagent.log" in connection info string
> 
> What's happen ?

The connection string options must always be last - try:

pgagent -l 1 -s /var/log/pgagent/pgagent.log hostaddr=127.0.0.1 
dbname=postgres user=postgres

Regards, Dave


Re: Where is located pgAgent log on Linux ?

From
"Sabin Coanda"
Date:
"Dave Page" <dpage@postgresql.org> wrote in message 
news:45F7B29D.1020408@postgresql.org...
> Sabin Coanda wrote:
>> Hi,
>>  Do you know where is located pgAgent log on Linux, please ?
>
> stderr, or you can use the -s option to specify a file.
>
> I noticed this is missing from the docs which I've now corrected.
>
> Regards, Dave.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                http://www.postgresql.org/about/donate
>

Hi Dave,

I start pgagent on linux with the following command:
       pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1

It works well and send the message logs to console.
But when I wish to log to a file, and I start it with the command:
       pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1 -s 
/var/log/pgagent/pgagent.log

It logs the following error:
       Couldn't create connection: missing "=" after 
"/var/log/pgagent/pgagent.log" in connection info string

What's happen ?

Regards,
Sabin 




Re: Where is located pgAgent log on Linux ?

From
"Sabin Coanda"
Date:
"Dave Page" <dpage@postgresql.org> wrote in message 
news:45F90E98.90500@postgresql.org...
> Sabin Coanda wrote:
>> "Dave Page" <dpage@postgresql.org> wrote in message 
>> news:45F7B29D.1020408@postgresql.org...
>>> Sabin Coanda wrote:
>>>> Hi,
>>>>  Do you know where is located pgAgent log on Linux, please ?
>>> stderr, or you can use the -s option to specify a file.
>>>
>>> I noticed this is missing from the docs which I've now corrected.
>>>
>>> Regards, Dave.
>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 7: You can help support the PostgreSQL project by donating at
>>>
>>>                http://www.postgresql.org/about/donate
>>>
>>
>> Hi Dave,
>>
>> I start pgagent on linux with the following command:
>>
>>         pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1
>>
>> It works well and send the message logs to console.
>> But when I wish to log to a file, and I start it with the command:
>>
>>         pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1 -s 
>> /var/log/pgagent/pgagent.log
>>
>> It logs the following error:
>>
>>         Couldn't create connection: missing "=" after 
>> "/var/log/pgagent/pgagent.log" in connection info string
>>
>> What's happen ?
>
> The connection string options must always be last - try:
>
> pgagent -l 1 -s /var/log/pgagent/pgagent.log hostaddr=127.0.0.1 
> dbname=postgres user=postgres
>
> Regards, Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>

I relaunched it:       pgagent -l 1 -s /var/log/pgagent/pgagent.log hostaddr=127.0.0.1 
dbname=postgres user=postgres

Unfortunatelly I got the same message:       WARNING: Couldn't create connection: missing "=" after 
"/var/log/pgagent/pgagent.log" in connection info string

:((

Regards, Sabin 




Re: Where is located pgAgent log on Linux ?

From
"Sabin Coanda"
Date:
"Dave Page" <dpage@postgresql.org> wrote in message 
news:45F90E98.90500@postgresql.org...
> Sabin Coanda wrote:
>> "Dave Page" <dpage@postgresql.org> wrote in message 
>> news:45F7B29D.1020408@postgresql.org...
>>> Sabin Coanda wrote:
>>>> Hi,
>>>>  Do you know where is located pgAgent log on Linux, please ?
>>> stderr, or you can use the -s option to specify a file.
>>>
>>> I noticed this is missing from the docs which I've now corrected.
>>>
>>> Regards, Dave.
>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 7: You can help support the PostgreSQL project by donating at
>>>
>>>                http://www.postgresql.org/about/donate
>>>
>>
>> Hi Dave,
>>
>> I start pgagent on linux with the following command:
>>
>>         pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1
>>
>> It works well and send the message logs to console.
>> But when I wish to log to a file, and I start it with the command:
>>
>>         pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1 -s 
>> /var/log/pgagent/pgagent.log
>>
>> It logs the following error:
>>
>>         Couldn't create connection: missing "=" after 
>> "/var/log/pgagent/pgagent.log" in connection info string
>>
>> What's happen ?
>
> The connection string options must always be last - try:
>
> pgagent -l 1 -s /var/log/pgagent/pgagent.log hostaddr=127.0.0.1 
> dbname=postgres user=postgres
>
> Regards, Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>

I relaunched it:       pgagent -l 1 -s /var/log/pgagent/pgagent.log hostaddr=127.0.0.1 
dbname=postgres user=postgres

Unfortunatelly I got the same message:       WARNING: Couldn't create connection: missing "=" after 
"/var/log/pgagent/pgagent.log" in connection info string

:((

Regards, Sabin 




Re: Where is located pgAgent log on Linux ?

From
Dave Page
Date:
Sabin Coanda wrote:
> I relaunched it:
>         pgagent -l 1 -s /var/log/pgagent/pgagent.log hostaddr=127.0.0.1 
> dbname=postgres user=postgres
> 
> Unfortunatelly I got the same message:
>         WARNING: Couldn't create connection: missing "=" after 
> "/var/log/pgagent/pgagent.log" in connection info string
> 
> :((

What version of the agent do you have? If you run pgagent --help, does 
it list the -s option?

Regards Dave,


Re: Where is located pgAgent log on Linux ?

From
"Sabin Coanda"
Date:
>
> What version of the agent do you have? If you run pgagent --help, does it 
> list the -s option?
>
> Regards Dave,

Hi Dave,

When I run pgagent --help, no help text is provided. Instead a new process 
pgagent is launched.

In fact I compiled locally the sources from 
http://www.postgresql.org/ftp/pgadmin3/release/v1.4.3/fedora-core-4/srpm/, 
because I found empty the directory 
http://www.postgresql.org/ftp/pgadmin3/release/v1.4.3/fedora-core-4/rpms/ . 
Maybe helps.

Regards, Sabin 




Re: Where is located pgAgent log on Linux ?

From
Dave Page
Date:
Sabin Coanda wrote:
>> What version of the agent do you have? If you run pgagent --help, does it 
>> list the -s option?
>>
>> Regards Dave,
> 
> Hi Dave,
> 
> When I run pgagent --help, no help text is provided. Instead a new process 
> pgagent is launched.
> 
> In fact I compiled locally the sources from 
> http://www.postgresql.org/ftp/pgadmin3/release/v1.4.3/fedora-core-4/srpm/, 
> because I found empty the directory 
> http://www.postgresql.org/ftp/pgadmin3/release/v1.4.3/fedora-core-4/rpms/ . 
> Maybe helps.

Yes, the -s option was added for 1.6. The 1.4 series is unsupported now 
- you should grab a copy of 1.6.2: 
http://www.postgresql.org/ftp/pgadmin3/release/v1.6.2/

Regards, Dave