[pgpool-general: 9093] Re: Problem on node3 Pgpool-II

[Alireza Kamrani]

Thanks, I'll check it out.

On Thu, 2 May 2024, 05:22 Bo Peng, <pengbo at sraoss.co.jp> wrote:

> Hi,
>
> > I did a setup PostgreSQL 16,  and Pgpool-II on Ubuntu 22.04,  to create a
> > 3_node cluster,
> > But backend_hostname3 is not being used by the pgpool !
>
> The number in backend_hostnameX should start from 0.
>
>
> https://www.pgpool.net/docs/latest/en/html/runtime-config-backend-settings.html
>
> If you want to create a 3 postgresql nodes cluster,
> you should set:
>
>   backend_hostname0
>   backend_hostname1
>   backend_hostname2
>
> If the settings above don't work, could you share your pgpool.conf and log
> files?
>
> > Is there limitations on Ubuntu or there is a solution for that??
> >
> > Also I had to make some changes on follow_primary.sh and recovery_1_stage
> > and all scripts contains postgresql.conf path,   because of
> postgresql.conf
> > is on /etc/postgres path by default but my Data directory is /data as
> > example when setup postgres on ubuntu.
>
> You need to modify the scripts to meet your setup.
>
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS LLC
> TEL: 03-5979-2701 FAX: 03-5979-2702
> URL: https://www.sraoss.co.jp/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240502/f5423145/attachment.htm>