Flavio e demais, Eu no logon do pgadmin3 desabilitei forcado a opcao do ssl. Como também testei via prompt de comando e dai consegui conectar, realizar consultas nomalmente. A unica mensagem de erro foi que de algumas features psql que não poderia funcionar porque meu cliente é PostgreSQL 8.4 e o servidor PostgreSQL 9.0. Analisando melhor o log encontei isso tb:
2012-03-27 14:58:05 DEBUG: pid 8617: Protocol Major: 1234 Minor: 5679 database: user: 2012-03-27 14:58:05 DEBUG: pid 8617: SSLRequest from client 2012-03-27 14:58:05 DEBUG: pid 8617: pool_ssl: SSL requested but SSL support is not available 2012-03-27 14:58:05 DEBUG: pid 8617: read_startup_packet: application_name: pgAdmin III - Browser 2012-03-27 14:58:05 DEBUG: pid 8617: Protocol Major: 3 Minor: 0 database: postgres user: pgpool 2012-03-27 14:58:05 DEBUG: pid 8617: new_connection: connecting 0 backend 2012-03-27 14:58:05 DEBUG: pid 8617: new_connection: connecting 1 backend 2012-03-27 14:58:05 DEBUG: pid 8617: pool_ssl: SSL requested but SSL support is not available 2012-03-27 14:58:05 DEBUG: pid 8617: pool_ssl: SSL requested but SSL support is not available 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length: slot: 0 length: 8 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length: slot: 1 length: 8 2012-03-27 14:58:05 DEBUG: pid 8617: pool_do_auth: auth kind:0 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 0 length: 43 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 1 length: 43 2012-03-27 14:58:05 DEBUG: pid 8617: 0 th backend: name: application_name value: pgAdmin III - Browser 2012-03-27 14:58:05 DEBUG: pid 8617: 1 th backend: name: application_name value: pgAdmin III - Browser 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 0 length: 25 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 1 length: 25 2012-03-27 14:58:05 DEBUG: pid 8617: 0 th backend: name: client_encoding value: UTF8 2012-03-27 14:58:05 DEBUG: pid 8617: 1 th backend: name: client_encoding value: UTF8 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 0 length: 23 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 1 length: 23 2012-03-27 14:58:05 DEBUG: pid 8617: 0 th backend: name: DateStyle value: ISO, MDY 2012-03-27 14:58:05 DEBUG: pid 8617: 1 th backend: name: DateStyle value: ISO, MDY 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 0 length: 25 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 1 length: 25 2012-03-27 14:58:05 DEBUG: pid 8617: 0 th backend: name: integer_datetimes value: on 2012-03-27 14:58:05 DEBUG: pid 8617: 1 th backend: name: integer_datetimes value: on 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 0 length: 27 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 1 length: 27 2012-03-27 14:58:05 DEBUG: pid 8617: 0 th backend: name: IntervalStyle value: postgres 2012-03-27 14:58:05 DEBUG: pid 8617: 1 th backend: name: IntervalStyle value: postgres 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 0 length: 20 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 1 length: 20 2012-03-27 14:58:05 DEBUG: pid 8617: 0 th backend: name: is_superuser value: on 2012-03-27 14:58:05 DEBUG: pid 8617: 1 th backend: name: is_superuser value: on 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 0 length: 25 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 1 length: 25 2012-03-27 14:58:05 DEBUG: pid 8617: 0 th backend: name: server_encoding value: UTF8 2012-03-27 14:58:05 DEBUG: pid 8617: 1 th backend: name: server_encoding value: UTF8 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 0 length: 25 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 1 length: 25 2012-03-27 14:58:05 DEBUG: pid 8617: 0 th backend: name: server_version value: 9.0.5 2012-03-27 14:58:05 DEBUG: pid 8617: 1 th backend: name: server_version value: 9.0.5 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 0 length: 33 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 1 length: 33 2012-03-27 14:58:05 DEBUG: pid 8617: 0 th backend: name: session_authorization value: pgpool 2012-03-27 14:58:05 DEBUG: pid 8617: 1 th backend: name: session_authorization value: pgpool 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 0 length: 36 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 1 length: 36 2012-03-27 14:58:05 DEBUG: pid 8617: 0 th backend: name: standard_conforming_strings value: off 2012-03-27 14:58:05 DEBUG: pid 8617: 1 th backend: name: standard_conforming_strings value: off 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 0 length: 25 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length2: master slot: 1 length: 25 2012-03-27 14:58:05 DEBUG: pid 8617: 0 th backend: name: TimeZone value: Brazil/East 2012-03-27 14:58:05 DEBUG: pid 8617: 1 th backend: name: TimeZone value: Brazil/East 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length: slot: 0 length: 12 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length: slot: 1 length: 12 2012-03-27 14:58:05 DEBUG: pid 8617: pool_do_auth: cp->info[i]:0x7f374fc80000 pid:7719 2012-03-27 14:58:05 DEBUG: pid 8617: pool_do_auth: cp->info[i]:0x7f374fc80088 pid:27208 2012-03-27 14:58:05 DEBUG: pid 8617: pool_send_auth_ok: send pid 27208 to frontend 2012-03-27 14:58:05 DEBUG: pid 8617: select_load_balancing_node: selected backend id is 1 2012-03-27 14:58:05 DEBUG: pid 8617: selected load balancing node: 1 2012-03-27 14:58:05 DEBUG: pid 8617: pool_unset_query_in_progress: done 2012-03-27 14:58:05 DEBUG: pid 8617: pool_unset_command_success: done 2012-03-27 14:58:05 DEBUG: pid 8617: pool_unset_writing_transaction: done 2012-03-27 14:58:05 DEBUG: pid 8617: pool_unset_failed_transaction: done 2012-03-27 14:58:05 DEBUG: pid 8617: pool_unset_transaction_isolation: done 2012-03-27 14:58:05 DEBUG: pid 8617: pool_unset_skip_reading_from_backends: done 2012-03-27 14:58:05 DEBUG: pid 8617: pool_unset_ignore_till_sync: done 2012-03-27 14:58:05 DEBUG: pid 8617: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2 2012-03-27 14:58:05 DEBUG: pid 8617: read_kind_from_backend: read kind from 1 th backend Z NUM_BACKENDS: 2 2012-03-27 14:58:05 DEBUG: pid 8617: ProcessBackendResponse: kind from backend: Z 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length: slot: 0 length: 5 2012-03-27 14:58:05 DEBUG: pid 8617: pool_read_message_length: slot: 1 length: 5 On Tue, Mar 27, 2012 at 15:05, Antonio Abner Junior < [email protected]> wrote: > Flávio Gurgel, >> > Realizei as alterações mas o erro persiste. > Alguma outra dica? > 2012-03-27 14:57:06 DEBUG: pid 8624: pool_ssl: SSL requested but SSL > support is not available. > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: auth kind: 0 > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: parameter status data > received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: parameter status data > received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: parameter status data > received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: parameter status data > received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: parameter status data > received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: parameter status data > received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: parameter status data > received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: parameter status data > received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: parameter status data > received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: parameter status data > received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: parameter status data > received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: backend key data received > 2012-03-27 14:57:06 DEBUG: pid 8624: s_do_auth: transaction state: I > 2012-03-27 14:57:06 DEBUG: pid 8624: do_query: kind: T > 2012-03-27 14:57:06 DEBUG: pid 8624: num_fileds: 1 > 2012-03-27 14:57:06 DEBUG: pid 8624: do_query: kind: D > 2012-03-27 14:57:06 DEBUG: pid 8624: do_query: kind: C > 2012-03-27 14:57:06 DEBUG: pid 8624: do_query: kind: Z > 2012-03-27 14:57:06 DEBUG: pid 8624: do_query: kind: T > 2012-03-27 14:57:06 DEBUG: pid 8624: num_fileds: 1 > 2012-03-27 14:57:06 DEBUG: pid 8624: do_query: kind: D > 2012-03-27 14:57:06 DEBUG: pid 8624: do_query: kind: C > 2012-03-27 14:57:06 DEBUG: pid 8624: do_query: kind: Z > Antonio Abner Junior - AJ > > Message: 5 > Date: Tue, 27 Mar 2012 12:12:35 -0300 > From: Flavio Henrique Araque Gurgel <[email protected]> > Subject: Re: [pgbr-geral] Problema com pgpool e hot standby, stream > replication > To: Comunidade PostgreSQL Brasileira > <[email protected]> > Message-ID: > <caghtaem3y5hk9oguk4qmgfo9ccq+_15tm6robhy2mh09db8...@mail.gmail.com > > > Content-Type: text/plain; charset=ISO-8859-1 > > > 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 > > Vá no pg_hba.conf dos servidores de banco e use hostnossl ao invés de > host ao iniciar uma linha. > > []s > Flavio Gurgel > > > > -- Antonio Abner Junior - AJ
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
