This is more a networking issue than a PostgreSQL one. What you'll like
want to do is to set up a nic in each box and use a "rolled" cable
directly between them. Assign an IP to each machine like 10.0.0.1 and
10.0.0.2 and edit your route tables to make each machine use those IPs
respectively to talk to each other. I'm a unix guy, so explaining
exactly how to do this in windows is a mystery to me. I'm guessing
windows because of the ASP you mention. The basic theory stays the same
though.
On Tue, 2004-10-19 at 10:05, Kent Anderson wrote:
> We are upgrading our servers and have run into an interesting
> situation. It has been proposed that we have a direct connection from
> the web servers to the postgres server via extra NICs. Has anyone done
> this before and how big a project would it be to alter ASP and Java
> applications to make use of such a connection?
>
> Before we even waste time installing the NIC's I would like a sense of
> how hard it is to get postgres to use that kind of a connection vs
> over the Internet. We are looking to increase communication speed
> between the web servers and database server as much as possible.
>
> Thanks
> Kent Anderson