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

[Yugo Nagata]

Hi,

Please check pgpool.conf carefully again. Is there are multiple rows of
'replicatoin_mode' option? If so, the last row's value is adopted.

If not, please check whether the correct pgpool.conf is used. You can specify
pgpool.conf path by -f option of pg_md5. If omitted, default path is used. You
can know the default as below;

$ pgpool -h
...
  -f, --config-file=CONFIG_FILE
                      Sets the path to the pgpool.conf configuration file
                      (default: /usr/local/pgpool/etc/pgpool.conf) <=
...


On Fri, 31 Jan 2014 15:17:50 -0600
espeake at oreillyauto.com wrote:

> 
> 
> 
> 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.


-- 
Yugo Nagata <nagata at sraoss.co.jp>