[Pgpool-general] Where did my logging go?

2010-01-11 Thread Ger Apeldoorn
Hi, I have upgraded recently to postgresql-pgpool-II-2.2.5 on Red Hat Enterprise Linux Server release 5.4. Since, I cannot see any logging from pgpool in /var/log/pgpool.log. Also, nothing can be found in /tmp. (logdir = '/tmp') There have been several events that should have been logged, lik

Re: [Pgpool-general] Where did my logging go?

2010-01-11 Thread Ramon de Carvalho Valle
If you are using the package in EPEL, uncomment the following line in /etc/sysconfig/pgpool: #OPTS=" -d -n" Remove the -n option and restart pgpool. On Mon, 2010-01-11 at 16:13 +0100, Ger Apeldoorn wrote: > Hi, > > I have upgraded recently to postgresql-pgpool-II-2.2.5 on Red Hat > Enterprise

Re: [Pgpool-general] Where did my logging go?

2010-01-13 Thread Ger Apeldoorn
Hi Ramon, Thank you, I get more debug info now on the console. Unfortunately, it is still not directed to a logfile. Any ideas? Thanks, Ger. Ramon de Carvalho Valle wrote: If you are using the package in EPEL, uncomment the following line in /etc/sysconfig/pgpool: #OPTS=" -d -n" Remove the

Re: [Pgpool-general] Where did my logging go?

2010-01-14 Thread Xavier Noguer
Hello Ger, I'm not familiar with the package you are using, but pgpool is usually started by a script which is in /etc/pgpool/scripts/pgpool.sh regardless of whether this script reads options from some other location. Pgpool writes its log to standard error by default so you should check this

Re: [Pgpool-general] Where did my logging go?

2010-01-15 Thread Ramon de Carvalho Valle
Hi, The log file is defined in the pgpool-II init script in /etc/init.d/pgpool: PGPOOLLOG=/var/log/pgpool.log Make sure that this file has read and write permissions to the user postgres. Best regards, On Thu, 2010-01-14 at 10:35 -0300, Xavier Noguer wrote: > Hello Ger, > > I'm not familiar

Re: [Pgpool-general] Where did my logging go?

2010-01-15 Thread Devrim GÜNDÜZ
On Mon, 2010-01-11 at 16:13 +0100, Ger Apeldoorn wrote: > I have upgraded recently to postgresql-pgpool-II-2.2.5 on Red Hat > Enterprise Linux Server release 5.4. > > Since, I cannot see any logging from pgpool in /var/log/pgpool.log. Please upgrade to 2.3.1 (from EPEL or yum.pgsqlrpms.org repo

Re: [Pgpool-general] Where did my logging go?

2010-01-15 Thread Devrim GÜNDÜZ
On Fri, 2010-01-15 at 15:17 +0200, Devrim GÜNDÜZ wrote: > Please upgrade to 2.3.1 (from EPEL or yum.pgsqlrpms.org repositories) > and let me know whether the issue still exists or not. IIRC I fixed it > in 2.2.5-2, but there are some more fixes in 2.3.1. To be more clear: 2.3.1 logs to /var/log/p

Re: [Pgpool-general] Where did my logging go?

2010-01-15 Thread Ger Apeldoorn
Hi Devrim, Thanks, I'll install the update on monday on the test-cluster. I'll let you know if it solved this issue. Thanks, Ger. Devrim GÜNDÜZ wrote: On Mon, 2010-01-11 at 16:13 +0100, Ger Apeldoorn wrote: I have upgraded recently to postgresql-pgpool-II-2.2.5 on Red Hat Enterprise Linux

Re: [Pgpool-general] Where did my logging go?

2010-01-15 Thread Ger Apeldoorn
Hi Ramon, It is set correctly (as are the rights of the file). It seems that there is a new version out that fixes this, (see the post from Devrim) I'll try that version and let you all know how it went. Greetings, Ger. Ramon de Carvalho Valle wrote: Hi, The log file is defined in the pgpo

Re: [Pgpool-general] Where did my logging go?

2010-01-17 Thread Ger Apeldoorn
Hi Devrim, I installed 2.3.1 and the logging is working again, thanks for fixing it! Greetings, Ger. On Fri, 2010-01-15 at 14:52 +0100, Ger Apeldoorn wrote: > Hi Devrim, > > Thanks, I'll install the update on monday on the test-cluster. > > I'll let you know if it solved this issue. > > Thank

Re: [Pgpool-general] Where did my logging go?

2010-01-17 Thread Devrim GÜNDÜZ
On Mon, 2010-01-18 at 07:55 +0100, Ger Apeldoorn wrote: > I installed 2.3.1 and the logging is working again, thanks for fixing > it! You are welcome :) Thanks for the feedback. Regards, -- Devrim GÜNDÜZ , RHCE Professional Services, Training, 24x7 Support Authors: PostgreSQL RPMs, PITRTools, P