[pgpool-general: 2776] Re: both pgpool servers are master and using the same virtual IP

[Yugo Nagata]

Hi,

On Tue, 15 Apr 2014 12:24:51 +0200
Attila Heidrich <attila.heidrich at gmail.com> wrote:

> Dear guys!
> 
> Where to find the problem in the situation above?
> 
> No logs at all, for some reason pgpool stopped logging (usually it uses
> syslog).

The followings seem a summarised results of some command (pcp command or
show pool_nodes?). I want to konw the actual command results. Could you 
please send me these, log messages, and pgpool.conf?

> 
> root at postgres-1:/etc/pgpool2# pool status
> Node: 0
> Host: postgres-1
> Port: 5433
> Weight: 0.500000
> Status: Up, in pool (1)
> Role: Master
> 
> Node: 1
> Host: postgres-2
> Port: 5433
> Weight: 0.500000
> Status: Up, in pool (1)
> Role: Master
> 
> root at postgres-2:/etc/pgpool2# pool status
> Node: 0
> Host: postgres-2
> Port: 5433
> Weight: 0.500000
> Status: Up, in pool and connected (2)
> Role: Master
> 
> Node: 1
> Host: postgres-1
> Port: 5433
> Weight: 0.500000
> Status: Up, in pool and connected (2)
> Role: Master
> 
> This isn't the first time, usually happens in a high load situation.
> 
> Attila


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