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

espeake at oreillyauto.com espeake at oreillyauto.com
Sat Feb 1 06:17:50 JST 2014




From:	Wolf Schwurack <wolf at uen.org>
To:	"espeake at oreillyauto.com" <espeake at oreillyauto.com>
Cc:	"pgpool-general at pgpool.net" <pgpool-general at pgpool.net>,
            "pgpool-general-bounces at pgpool.net"
            <pgpool-general-bounces at pgpool.net>
Date:	01/31/2014 03:10 PM
Subject:	RE: [pgpool-general: 2517] Re: Trouble creating pool_passwd



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



# 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)


I still get this error:

pool_config: replication_mode and master_slave_mode cannot be enabled at
the same time
Unable to get configuration. Exiting...

Thanks,
Eric



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