[pgpool-general: 2518] Re: Trouble creating pool_passwd

Sat Feb 1 06:10:08 JST 2014

I used this command for pool_passwd
Ubuntu 10.4 pgool 3.3.0
As postgres user
 $ /usr/local/bin/pg_md5 --md5auth --username=joe -p

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wolf at uen.org

-----Original Message-----
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of espeake at oreillyauto.com
Sent: Friday, January 31, 2014 2:00 PM
To: espeake at oreillyauto.com
Cc: pgpool-general at pgpool.net; pgpool-general-bounces at pgpool.net
Subject: [pgpool-general: 2517] Re: Trouble creating pool_passwd

Any ideas?  I can't move forward with the setup with out being able to get this working.

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

From:	espeake at oreillyauto.com
To:	pgpool-general at pgpool.net
Date:	01/28/2014 01:42 PM
Subject:	[pgpool-general: 2498] Trouble creating pool_passwd
Sent by:	pgpool-general-bounces at pgpool.net

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.

--
This message has been scanned for viruses and dangerous content, and is believed to be clean.
  Message id: EF35B6012AB.A57DA

_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general

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.
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general