[Pgpool-general] Where did my logging go?

Ger Apeldoorn ger.apeldoorn at sara.nl
Fri Jan 15 13:54:11 UTC 2010


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 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 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 script, or any other script you may be using to start pgpool, and
>> make sure standard error is being directed to the logfile of your
>> choosing. For example:
>>
>> /usr/local/bin/pgpool -n -d 2>/usr/local/bin/pgpool
>>
>>
>>  Regards
>>
>> On Thu, 2010-01-14 at 08:44 +0100, Ger Apeldoorn wrote:
>>     
>>> 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 -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 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, like node 
>>>>> out-of-sync and repair.
>>>>> The latest entries in /var/log/pgpool.log are those when I shut down the 
>>>>> previous version right before the update.
>>>>>
>>>>> How can I get pgpool to generate more logging?
>>>>>
>>>>> Thanks in advance,
>>>>> Ger.
>>>>>
>>>>> _______________________________________________
>>>>> Pgpool-general mailing list
>>>>> Pgpool-general at pgfoundry.org
>>>>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>>>>     
>>>>>           
>>>>   
>>>>         
>>> _______________________________________________
>>> Pgpool-general mailing list
>>> Pgpool-general at pgfoundry.org
>>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>>       
>
>   


More information about the Pgpool-general mailing list