[pgpool-general: 5098] Re: pgpool.log file

Wolf Schwurack wolf at uen.org
Thu Nov 3 01:26:16 JST 2016


I found the issue

If “enable_pool_hba = on” in pgpool.conf then I get “^@” sign in pgool.log file when connecting. If “enable_pool_hba=off” I don’t get “^@” signs in pgpool.log file.

Is this how this should work? Having a bunch of “^@” in the pgpool.log file makes it hard to troubleshoot issues when trying read pgpool.log.

From: "pgpool-general-bounces at pgpool.net" <pgpool-general-bounces at pgpool.net> on behalf of Wolfgang Schwurack <wolf at uen.org>
Date: Wednesday, November 2, 2016 at 10:02 AM
To: "'pgpool-general at pgpool.net'" <pgpool-general at pgpool.net>
Subject: [pgpool-general: 5097] Re: pgpool.log file

I notice that ‘data’ pgpool.log contants ‘^@^@’ When I remove ‘^@^@’ from pgpool.log Then it shows the file as ASCII.

We use watchdog on our pgpool servers

To recreate – When using psql with the watchdog connection command it puts ‘^@^@’ signs in pgpool.log file but if I psql on the postgresql host it doesn’t put the ‘^@’ sign in the log file.

This only happens on my development and test hosts

All of our applications connect using watchdog connection command

From pgpool hosts connecting to postgres - I get ‘^@’ sign into pgpool.log file
$ psql –h wd-pgdev –p 9999

From postgresql host connecting to postgres – no ‘^@” sign into pgpool.log file
$ psql


Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wolf at uen.org<mailto:wolf at uen.org>




From: "pgpool-general-bounces at pgpool.net" <pgpool-general-bounces at pgpool.net> on behalf of Wolfgang Schwurack <wolf at uen.org>
Date: Wednesday, November 2, 2016 at 9:11 AM
To: "'pgpool-general at pgpool.net'" <pgpool-general at pgpool.net>
Subject: [pgpool-general: 5096] pgpool.log file

My development pgpool server the pgpool.log file show that it’s a binary file but on my production pgpool server show the file as ASCII. Both servers are setup the same.

Anyone know why one file is binary and the other is ASCII?

I use the same command on both to start pgpool
pgpool -n -D -f /usr/local/etc/pgpool.conf > /var/log/pgpool/pgpool.log

Version
pgpool-II version 3.5.4 (ekieboshi)

Host
Ubuntu 14.04.5 LTS

Production server
# file /var/log/pgpool/pgpool.log
/var/log/pgpool/pgpool.log: ASCII text

Development server
# file /var/log/pgpool/pgpool.log
/var/log/pgpool/pgpool.log: data


Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wolf at uen.org<mailto:wolf at uen.org>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161102/4fd78045/attachment-0001.html>


More information about the pgpool-general mailing list