[pgpool-general: 4436] Re: Pgpool master-slave mode

[Дмитрий Воронин]

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