[Pgpool-general] Master/Slave Load Balancing Configuration

[Ow Mun Heng]

On Fri, 2008-01-04 at 18:19 +0900, Yoshiyuki Asaba wrote:
> I cannot reproduce it in my environment.
> 
>   % pgpool -n -d -f pgpool.conf &; sleep 5; psql -p 9999 -c 'select 1' postgres
>   ...
>   DEBUG: pid 28641: select_load_balancing_node: selected backend id is 1
>   ...
>   LOG:   pid 28641: statement: select 1; *** select slave node ***
>   DEBUG: pid 28641: waiting for backend 0 completing the query
>   DEBUG: pid 28641: read_kind_from_backend: read kind from 0 th backend T NUM_BACKENDS: 1
>   DEBUG: pid 28641: pool_process_query: kind from backend: T
>   DEBUG: pid 28641: read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 1
>   DEBUG: pid 28641: pool_process_query: kind from backend: D
>   DEBUG: pid 28641: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 1
>   DEBUG: pid 28641: pool_process_query: kind from backend: C
> 
> Can you show us debug log?


pgpool -n -d -f /tmp/pgpool-test.conf 2>/tmp/log_pgpool >&1
psql -Uoperator -d hmxmms -h pgpool_server -c 'select 1' -p 9999


DEBUG: pid 11472: I am 11472 accept fd 6
DEBUG: pid 11472: Protocol Major: 1234 Minor: 5679 database:  user:
DEBUG: pid 11472: SSLRequest: sent N; retry startup
DEBUG: pid 11472: Protocol Major: 3 Minor: 0 database: hmxmms user: operator
DEBUG: pid 11472: connecting postmaster Unix domain socket: /tmp/.s.PGSQL.5432 <--------
DEBUG: pid 11472: connected to postmaster Unix domain socket: /tmp/.s.PGSQL.5432 fd: 7 <-----
DEBUG: pid 11472: trying md5 authentication
ERROR: pid 11472: pool_read: EOF encountered
ERROR: pid 11472: do_md5_password: failed to read password packet "p"
ERROR: pid 11472: pool_do_auth: backend does not return authenticaton ok
DEBUG: pid 11472: I am 11472 accept fd 6
DEBUG: pid 11472: Protocol Major: 1234 Minor: 5679 database:  user:
DEBUG: pid 11472: SSLRequest: sent N; retry startup
DEBUG: pid 11472: Protocol Major: 3 Minor: 0 database: hmxmms user: operator
DEBUG: pid 11472: connecting postmaster Unix domain socket: /tmp/.s.PGSQL.5432
DEBUG: pid 11472: connected to postmaster Unix domain socket: /tmp/.s.PGSQL.5432 fd: 7
DEBUG: pid 11472: trying md5 authentication
DEBUG: pid 11472: name: client_encoding value: SQL_ASCII
DEBUG: pid 11472: name: DateStyle value: ISO, MDY
DEBUG: pid 11472: name: integer_datetimes value: off
DEBUG: pid 11472: name: is_superuser value: on
DEBUG: pid 11472: name: server_encoding value: SQL_ASCII
DEBUG: pid 11472: name: server_version value: 8.2.5
DEBUG: pid 11472: name: session_authorization value: operator
DEBUG: pid 11472: name: standard_conforming_strings value: off
DEBUG: pid 11472: name: TimeZone value: Asia/Kuala_Lumpur
DEBUG: pid 11472: read kind from backend pending data Z len: 5 po: 287
DEBUG: pid 11472: ReadyForQuery: message length: 5
DEBUG: pid 11472: ReadyForQuery: transaction state: I
DEBUG: pid 11472: read kind from frontend Q(51)
DEBUG: pid 11472: Query: select 1
DEBUG: pid 11472: read kind from backend T
DEBUG: pid 11472: read kind from backend pending data D len: 29 po: 34
DEBUG: pid 11472: read kind from backend pending data C len: 17 po: 46
DEBUG: pid 11472: read kind from backend pending data Z len: 5 po: 58
DEBUG: pid 11472: ReadyForQuery: message length: 5
DEBUG: pid 11472: ReadyForQuery: transaction state: I
DEBUG: pid 11472: read kind from frontend X(58)
DEBUG: pid 11472: Query: RESET ALL
DEBUG: pid 11472: read kind from backend C
DEBUG: pid 11472: read kind from backend pending data Z len: 5 po: 11
DEBUG: pid 11472: ReadyForQuery: message length: 5
DEBUG: pid 11472: ReadyForQuery: transaction state: I
DEBUG: pid 11472: pool_connection_pool_timer: called

Notice the Arrows, For some reason, it seems to talk to a domain socket.

pgpool.conf
replication_mode = false
master_slave_mode = true
load_balance_mode = true
backend_hostname0 = 'pgmaster'
backend_port0 = 5432
backend_weight0 = 0.2
backend_hostname1 = 'pgslave'
backend_port1 = 5432
backend_weight1 = 0.8


/etc/hosts file is updated on the server to reflect the correct IP addresses.

Many Thanks.