Srs estou com um problema e gostaria de compartilhar, pois acredito que alguém ja tenha passado por isso.
Possuo um ambiente com pgpool2+ hot stand by + stream replication em que cada nó do postgresql esta em VMs distintas e o pgpool em outra. O SO é o redhat6 e fiz a implementação e estava funcionando tudo normalmente, qdo fui realizar o testes de failover ele não ocorreu por conta dos scripts. Eu havia antes de tudo realizado uma snapshot das vm's e voltei elas a este estado no entanto verifiquei que a replicação do stream esta ok, mas não consigo logar no pgpool com o pgadmin3 da minha máquina local de jeito nenhum. Verifiquei que o SSL está desabilitado em todas as máquinas. Segue log. 2012-03-27 11:10:32 LOG: pid 7588: pgpool-II successfully started. version 3.1 (hatsuiboshi) 2012-03-27 11:10:32 DEBUG: pid 7738: I am 7738 2012-03-27 11:10:32 DEBUG: pid 7738: pool_initialize_private_backend_status: initialize backend status 2012-03-27 11:10:32 DEBUG: pid 7734: I am 7734 2012-03-27 11:10:32 DEBUG: pid 7734: pool_initialize_private_backend_status: initialize backend status 2012-03-27 11:10:32 DEBUG: pid 7740: I am 7740 2012-03-27 11:10:32 DEBUG: pid 7740: pool_initialize_private_backend_status: initialize backend status 2012-03-27 11:10:32 DEBUG: pid 7666: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7664: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: auth kind: 0 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: parameter status data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: parameter status data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: parameter status data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: parameter status data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: parameter status data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: parameter status data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: parameter status data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: parameter status data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: parameter status data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: parameter status data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: parameter status data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: backend key data received 2012-03-27 11:10:32 DEBUG: pid 7635: s_do_auth: transaction state: I 2012-03-27 11:10:32 DEBUG: pid 7659: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7669: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7740: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7588: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7670: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7662: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7673: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7675: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7674: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7668: pool_ssl: SSL requested but SSL support is not available 2012-03-27 11:10:32 DEBUG: pid 7665: pool_ssl: SSL requested but SSL support is not available -- Antonio Abner Junior - AJ
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
