Thread: Where is located pgAgent log on Linux ?
Hi,
Do you know where is located pgAgent log on Linux, please ?
TIA,
Sabin
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.
"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
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
"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
"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
"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
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,
> > 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
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