[pgpool-general: 4474] Re: Configuration pgpool in Ubuntu

[Jorge Luis Iten Júnior]

Sorry guys, my bad.

Now I have configured it as replication, I notice the following unecpected
scenarios:
Scenario 1:
2 servers up:
1 connect to the pg cluster;
execute a insert sql or a create statement.
the instruction is replicated in node 0 but not node 1.
Scenario 2:
only node 1 up
1 connect to the pg cluster;
execute a insert sql or a create statement.
the instruction is executed correctly in node 1.
It seems that pgpool is replacating only in one server.
What Can I do?


On Fri, Feb 19, 2016 at 7:04 AM Tatsuo Ishii <ishii at postgresql.org> wrote:

> Have checked the FAQ?
>
>
> http://pgpool.net/mediawiki/index.php/FAQ#pgpoolAdmin_Frequently_Asked_Questions
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
> > Hi All,
> >
> > I am configuring pgpool over ubuntu, here are my settings:
> > Ubuntu 14.04.3 LTS
> > postgreSQL 9.3 on both databases
> > pgadmin 3.3.1 on cluster
> > And I am following this link
> > <http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/>
> as
> > a guide.
> > I've already done every step of the tutorial, but my database still up
> but
> > disconnected:
> > [image: pasted1]
> >
> > I am able to connect all machines through ssh without password.
> pgpool.log
> > does not show any error (attached). My pgpool.conf is basically the same
> as
> > the shown in the tutorial I just have changed the IP's.
> > Any tip why it still disconnected?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160219/0d0bd636/attachment.html>