[Pgpool-general] Trouble with pgpool installation

[Paul Giblock]

Possibly related, I'm also receiving this "DEBUG" message, so it may
be a concern:

pool_ssl: SSL requested but SSL support is not available

I did some research on it and it appears that pgpool is trying SSL for
authentication and trusted auth is required.  However on all my
database servers I have the following in my pg_hba:

host    all    all    10.103.31.1/24    trust

I have also verified this setting, I can use the psql command with no
password or other authentication options.  In pgpool.conf:

ssl = false
ssl_key = ''
ssl_cert = ''
ssl_ca_cert = ''
ssl_ca_cert_dir = ''

This is just a "DEBUG" message, so I guess it is fine - but I wonder
why SSL is being requested - my network is trusted and I'd rather not
have the encryption overhead.

Thanks,
Paul

On Thu, Jun 9, 2011 at 9:52 AM, Paul Giblock <pgiblox at gmail.com> wrote:
> Tatsuo,
>
> Thanks for the response.
>
>> pg_last_xlog_receive_location only returns meaningfull result on
>> standby. You should connect directly to standby and issue the
>> query. Even if you do that, I suspect you will get NULL since pgpool
>> log says however.
>>
>>> ERROR: pid 8733: check_replication_time_lag: SELECT
>>> pg_last_xlog_receive_location() returns no data
>>
>> This indicates that your standby server does not act as standby. You
>> should check your standby postgres log.
>
> I just tried pg_last_xlog_receive_location against both databases and
> both of them returned null.
>
> I'm not sure which database is "standby" as I never got to designate a
> "primary".  I also have no node status in pgpoolAdmin.  I issued a
> statement against pgpool. The statement was handled by server srvh035.
>  Even with multiple sessions it seems all statements are sent to
> srvh035.  Therefore, I assume srvh016 is currently in "standby".  What
> am I looking for in its log?  The only thing I see are many calls to:
>
> SELECT pg_last_xlog_receive_location()
>
>> I'm confused. streaming replication mode does not require system
>> db. Why did you do so?
>
> I did that because I was getting those errors regarding "no data", and
> it was a last-ditch effort to get things to work.
>
> Thank you,
> Paul
>