0 Replies Latest reply on Jun 6, 2012 2:49 AM by gakopyan

    JBoss 7.1.1 with PostgreSQL 9.*. How to config HA?

    gakopyan

      Hello there!

       

      I have JBoss 7.1.1 and two Postgres database hosts on 192.168.0.1 and 192.168.0.2

      My config:

       

                          ...

                        <datasource jndi-name="java:/RevolutionDS" pool-name="RevolutionDS" enabled="true" use-java-context="true" use-ccm="false">

                          <connection-url>jdbc:postgresql://192.168.0.1:5432/revolution|jdbc:postgresql://192.168.0.2:5432/revolution</connection-url>

                           <driver>org.postgresql.xa</driver>

                              <url-delimiter>|</url-delimiter>

                              <security>

                                  <user-name>revolution</user-name>

                                  <password>revolution</password>

                              </security>

                          </datasource>

                          ...

                          <drivers>

                              <driver name="h2" module="com.h2database.h2">

                                  <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

                              </driver>

                              <driver name="org.postgresql" module="org.postgresql">

                                  <driver-class>org.postgresql.Driver</driver-class>

                              </driver>

                              <driver name="org.postgresql.xa" module="org.postgresql">

                                  <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>

                              </driver>

                          </drivers>

                          ...

       

      If databases on on 192.168.0.1 and 192.168.0.2 available, everything works fine. But if I stop database on 192.168.0.1 error occurs. If I restart JBoss with stopped database on 192.168.0.1 (and available on 192.168.0.2) everything ok.

      Please help...