<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<div><br>> <br>> If you can provide some more information about your requirements that might suggest a cleared focus on one tool or another.<br>> <br>> HTH,<br>> <br>> Greg Williamson<br>> <br><br></div><div>The ideal scenario is 2 identical servers sitting behind 1 ip adress. The user uses this ip as POSTGIS server and couldn't even know if its geodatabase service is server by 1 postgis or two or three (i used to work for a non gis app with oracle RAC and i thought it would be possible to do something similar with postgres+postgis).</div><div><br></div><div>I thought that pgpool II could do this for me, but I'm not aware how this could work with POSTGIS.</div><div>I can also use a master server replicated (with postgres streaming replication) on a second server which is used only for querying but i want to know what happens if master dies. Does the replica become a new master trasparently for the clients or do they have to connect to a different ip?</div><div><br></div><div>The GIS data that i except to manage are 10gb in several tables. I also expect that the user wants to creare in the POSTGIS server new geographic tables.</div><div><br></div><div>Thanks for any advice!!!</div> </div></body>
</html>