Guido Neitzer wrote:
On 14.12.2005, at 16:46 Uhr, Richard Huxton wrote:

I'd be tempted to look at pgpool sitting between your application and the database, and then replication from the one machine to the other.

Right, I thought the same, BUT: I have two application servers (one on each machine) connecting to a network URL via JDBC. When pgpool is involved, I assume it only runs on one server, right?

Or can I have pgpool running on both servers, each knowing about the two servers and the applications just connect to "localhost"?

That's the sort of thing I was thinking of. Keep the application ignorant of the actual setup.

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to