Sabin Coanda wrote:
"Dave Page" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
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
