> > If you can provide some more information about your requirements that might > suggest a cleared focus on one tool or another. > > HTH, > > Greg Williamson >
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). I thought that pgpool II could do this for me, but I'm not aware how this could work with POSTGIS.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? 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. Thanks for any advice!!!
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users