we test pgpool-II with Shared Storage (Active-Standby)..

From: =?EUC-KR?B?s+vH9ryu?=<noh019(at)naver(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: we test pgpool-II with Shared Storage (Active-Standby)..
Date: 2010-08-13 08:43:58
Message-ID: 728c6a3872f4b0563f5f1778a9c80101@tweb16-2.nm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


hi..

1
#############################################
we test pgpool-II with Shared Storage (Active-Standby)..

pgpool-II test(192.168.2.99)
Active rac1 (192.168.2.61)
Stadnby rac2 (192.168.2.71)

2
#############################################
we have question...

1>
============================
when, power-off rac1
-> pgpool-II failover_command='/tmp/failover1.sh' execute,
--> rac2 filesystem mount (/u03/postgres), and postgres start
--->and, client can connect DB (in rac2)

&lt;=== It's ok...

2>
============================
and then, boot rac1,
and then , power-off rac2
-> pgpool-II failover_command'/tmp/failover2.sh' execute
--> rac1 filesystem mount (/u03/postgres), and postgres start ,
---> BUT, client can not connect DB (in rac1)

&lt;=== this is our problem...,
&lt;=== so, we restart pgpool-II (not postgresql)...... and then client can connect DB...

3
#############################################
Could you teach me, Is this expected behavior ?
and,
how can we overcome this issue...

Thanks..

noh019님의 블로그
안녕하세요.









noh019님의 블로그
안녕하세요.




Browse pgsql-general by date

  From Date Subject
Next Message Daniel Migowski 2010-08-13 08:57:13 Feature Request: bzip2 support in pg_dump, pg_restore
Previous Message Torsten Zühlsdorff 2010-08-13 08:11:30 Re: InitDB: Bad system call