[pgpool-general: 4436] Re: Pgpool master-slave mode
Дмитрий Воронин
carriingfate92 at yandex.ru
Wed Feb 10 23:17:56 JST 2016
Sorry, It was my error.
I forgot to set params sr_check_user and sr_check_password in pgpool.conf to checking replication's status. Sorry.
> node_id | hostname | port | status | lb_weight | role
> ---------+-----------+------+--------+-----------+---------
> 0 | 127.0.0.1 | 5432 | 2 | 0.500000 | standby
> 1 | 127.0.0.1 | 5433 | 2 | 0.500000 | standby
> (2 rows)
>
> So, the questions are:
> - Why pgpool determines all nodes as stanby?
> - In this case I can't execute DDL statetements like CREATE TABLE ... because I have error: In transaction "read only" can not execute CREATE TABLE
>
--
Best regards, Dmitry Voronin
More information about the pgpool-general
mailing list