>> Red Hat Enterprise Linux Server release 6.1
>> PostgreSQL 9.0
>> pgpool-II version 3.1

Ok.

>> # PARALLEL MODE AND QUERY CACHE
>>
>> #------------------------------------------------------------------------------
>>
>> parallel_mode = on

Você *não* pode habilitar parallel_mode junto com master/slave mode.
Desabilite aqui.

>> # - System DB info -
>>
>> system_db_hostname  ='serv2'
>>                                    # (change requires restart)
>> system_db_port = 5432
>>                                    # (change requires restart)
>> system_db_dbname = 'pgpool'
>>                                    # (change requires restart)
>> system_db_schema = 'pgpool_catalog'
>>                                    # (change requires restart)
>> system_db_user = 'usrpgpool'
>>                                    # (change requires restart)
>> system_db_password = ''
>>                                    # (change requires restart)

Desabilite estes parâmetros. Eles só server para parallel_mode.

>> failover_command = '/usr/pgpool-9.0/bin/failover_stream.sh 0 serv02
>> /tmp/arquivo_gatilho.pgsql'

Ok.

>> fail_over_on_backend_error = on

Ok.

Tente desabilitar o parallel_mode e veja se resolve seu problema.

[]s
Flavio Gurgel
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a