[pgpool-general: 2498] Trouble creating pool_passwd

espeake at oreillyauto.com espeake at oreillyauto.com
Wed Jan 29 04:41:58 JST 2014


I am using the following command to create my pool_passwd file.

pg_md5 -m <password> -u <pgpool_user>

And this is the results from running the command

2014-01-28 11:26:36 DEBUG: pid 15432: key: pid_file_name
2014-01-28 11:26:36 DEBUG: pid 15432: value: '/var/run/pgpool/pgpool.pid'
kind: 4
2014-01-28 11:26:36 DEBUG: pid 15432: key: logdir
2014-01-28 11:26:36 DEBUG: pid 15432: value: '/tmp' kind: 4
2014-01-28 11:26:36 DEBUG: pid 15432: key: connection_cache
2014-01-28 11:26:36 DEBUG: pid 15432: value: on kind: 1
2014-01-28 11:26:36 DEBUG: pid 15432: key: reset_query_list
2014-01-28 11:26:36 DEBUG: pid 15432: value: 'ABORT; DISCARD ALL' kind: 4
2014-01-28 11:26:36 DEBUG: pid 15432: extract_string_tokens: token: ABORT
2014-01-28 11:26:36 DEBUG: pid 15432: extract_string_tokens: token:
DISCARD ALL
2014-01-28 11:26:36 DEBUG: pid 15432: key: replication_mode
2014-01-28 11:26:36 DEBUG: pid 15432: value: on kind: 1
2014-01-28 11:26:36 DEBUG: pid 15432: key: replicate_select
2014-01-28 11:26:36 DEBUG: pid 15432: value: on kind: 1
2014-01-28 11:26:36 DEBUG: pid 15432: replicate_select: 1
2014-01-28 11:26:36 DEBUG: pid 15432: key: insert_lock
2014-01-28 11:26:36 DEBUG: pid 15432: value: off kind: 1
2014-01-28 11:26:36 DEBUG: pid 15432: key: lobj_lock_table
2014-01-28 11:26:36 DEBUG: pid 15432: value: '' kind: 4
2014-01-28 11:26:36 DEBUG: pid 15432: key: replication_stop_on_mismatch
2014-01-28 11:26:36 DEBUG: pid 15432: value: off kind: 1
2014-01-28 11:26:36 DEBUG: pid 15432: replication_stop_on_mismatch: 0
2014-01-28 11:26:36 DEBUG: pid 15432: key:
failover_if_affected_tuples_mismatch
2014-01-28 11:26:36 DEBUG: pid 15432: value: off kind: 1
2014-01-28 11:26:36 DEBUG: pid 15432: failover_if_affected_tuples_mismatch:
0
2014-01-28 11:26:36 DEBUG: pid 15432: key: load_balance_mode
2014-01-28 11:26:36 DEBUG: pid 15432: value: on kind: 1
2014-01-28 11:26:36 DEBUG: pid 15432: key: ignore_leading_white_space
2014-01-28 11:26:36 DEBUG: pid 15432: value: on kind: 1
2014-01-28 11:26:36 DEBUG: pid 15432: key: white_function_list
2014-01-28 11:26:36 DEBUG: pid 15432: value: '' kind: 4
2014-01-28 11:26:36 DEBUG: pid 15432: key: black_function_list
2014-01-28 11:26:36 DEBUG: pid 15432: value:
'currval,lastval,nextval,setval' kind: 4
2014-01-28 11:26:36 DEBUG: pid 15432: extract_string_tokens: token: currval
2014-01-28 11:26:36 DEBUG: pid 15432: extract_string_tokens: token: lastval
2014-01-28 11:26:36 DEBUG: pid 15432: extract_string_tokens: token: nextval
2014-01-28 11:26:36 DEBUG: pid 15432: extract_string_tokens: token: setval
2014-01-28 11:26:36 DEBUG: pid 15432: add_to_patterns: regex pattern:
^currval$
2014-01-28 11:26:36 DEBUG: pid 15432: add_to_patterns: regex pattern:
^lastval$
2014-01-28 11:26:36 DEBUG: pid 15432: add_to_patterns: regex pattern:
^nextval$
2014-01-28 11:26:36 DEBUG: pid 15432: add_to_patterns: regex pattern:
^setval$
2014-01-28 11:26:36 DEBUG: pid 15432: key: master_slave_mode
2014-01-28 11:26:36 DEBUG: pid 15432: value: on kind: 1
2014-01-28 11:26:36 ERROR: pid 15432: pool_config: replication_mode and
master_slave_mode cannot be enabled at the same time
Unable to get configuration. Exiting...

Replication Mode is off and I am using the stream example file for my
pgpool.conf file.  With the following information in it.

# REPLICATION MODE
#------------------------------------------------------------------------------

replication_mode = off
                                   # Activate replication mode
                                   # (change requires restart)
replicate_select = off
                                   # Replicate SELECT statements
                                   # when in replication or parallel mode
                                   # replicate_select is higher priority
than
                                   # load_balance_mode.

insert_lock = off
                                   # Automatically locks a dummy row or a
table
                                   # with INSERT statements to keep SERIAL
data
                                   # consistency
                                   # Without SERIAL, no lock will be issued
lobj_lock_table = ''
                                   # When rewriting lo_creat command in
                                   # replication mode, specify table name
to
                                   # lock

# - Degenerate handling -

replication_stop_on_mismatch = off
                                   # On disagreement with the packet kind
                                   # sent from backend, degenerate the node
                                   # which is most likely "minority"
                                   # If off, just force to exit this
session

failover_if_affected_tuples_mismatch = off
                                   # On disagreement with the number of
affected
                                   # tuples in UPDATE/DELETE queries, then
                                   # degenerate the node which is most
likely
                                   # "minority".
                                   # If off, just abort the transaction to
                                   # keep the consistency


master_slave_mode = on
                                   # Activate master/slave mode
                                   # (change requires restart)
master_slave_sub_mode = 'stream'
                                   # Master/slave sub mode
                                   # Valid values are combinations slony or
                                   # stream. Default is slony.
                                   # (change requires restart)

Help please.


Thanks,
Eric Speake
Web Systems Administrator
O'Reilly Auto Parts

This communication and any attachments are confidential, protected by Communications Privacy Act 18 USCS § 2510, solely for the use of the intended recipient, and may contain legally privileged material. If you are not the intended recipient, please return or destroy it immediately. Thank you.


More information about the pgpool-general mailing list