Re: FW: Configuring Postgres to use unix sockets - Mailing list pgsql-general

From Douglas McNaught
Subject Re: FW: Configuring Postgres to use unix sockets
Date
Msg-id m2slwee4dd.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to FW: Configuring Postgres to use unix sockets  ("John Zubac" <jzubac@internetsecure.com>)
Responses Re: FW: Configuring Postgres to use unix sockets
List pgsql-general
"John Zubac" <jzubac@internetsecure.com> writes:

> Hi Everyone
>
> I am not too sure how to do this but I'll ask
>
> I want two postgres servers to communicate over a serial port. I want to
> avoid using the TCP/IP network protocol for added security. I heard this
> can be accomplished through unix sockets? Could anyone give me some
> configuration advice. I am a little in the dark with this type of config.

Unix sockets can't work across a serial link.

You would need to run PPP over the serial link between the two
machines, then make TCP connections using that network.  It'd be
*much* faster and less hassle to simply put a second NIC in each
machine, connect them with a crossover cable, and run your PG
connections over that network.  You could also enforce use of the
private network (in both cases) by use of firewall rules.

-Doug

pgsql-general by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: Re: Is this a bug or am I doing something wrong?
Next
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: FW: Configuring Postgres to use unix sockets