Thread: Postgresql, Windows, Peer-2-Peer network

Hello,

    I don't see why not. You may have to turn on the PG Server to listen
for connections coming in via TCP so that the other machines can connect
to it, as well as install the client related stuff on the other client
machines accessing the machine running the PG server.

    Cheers,

    Aly.

Typing80wpm@aol.com wrote:
> At work, we have five workstations running Windows XP (Home edition),
> connected peer to peer.  I do not know that much about interner or
> intranet.  But, each machine has its own IP address, and one printer is
> accessible from the five machines, and the printer has its own IP address.
>
> IS IT POSSIBLE to install Postgresql for windows as a service on one of
> the machines (as I did on my home machine, specifing "localhost") but
> then have the other machines access the PG server through the internet
> address of that machine (the quad address)?
>
> - Thanks in advance for your help!

--
Aly Dharshi
aly.dharshi@telus.net

          "A good speech is like a good dress
           that's short enough to be interesting
           and long enough to cover the subject"

OF COURSE as long as the PC is NT or greater(won't work on windows 95/98).
just make sure you modify the pg_hba.conf file to allow the other PCs to
access and change the postgresql.conf file to listen on all i.e. *

You could even use PG Lightning Admin with it's built in SSH tunnel
support, or Putty.exe and have all the other machines connect via
encrypted SSH, then you could simply leave your server to allow
connections only from localhost.

--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql 8.x
http://www.amsoftwaredesign.com

>
> IS IT POSSIBLE to install Postgresql for windows as a service on one
> of the machines (as I did on my home machine, specifing "localhost")
> but then have the other machines access the PG server through the
> internet address of that machine (the quad address)?
>
> - Thanks in advance for your help!