Conditions to be connected through UNIX-sockets ?

From: "Bruno BAGUETTE" <pgsql-ml(at)baguette(dot)net>
To: "'PostgreSQL-general'" <pgsql-general(at)postgresql(dot)org>
Subject: Conditions to be connected through UNIX-sockets ?
Date: 2003-07-10 11:05:57
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAHX8AIwMTWkm7mfxDlByvdQEAAAAA@baguette.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

In order to improve the speed, I would like to know the conditions to be
connected through unix sockets (faster) instead tcp sockets (slower).

If I specify only the database name (with or without login/password), I
assume that I will be connect to the PostgreSQL through Unix Sockets.

What will be used (unix or tcpip sockets) if :

- I set a specific port (5433, for example) but not hostname ?
- I set the localhost hostname or the 127.0.0.1 ip ?
- I set the 'external' IP of the machine (ex. 192.168.0.20) and that I
make the call from the same machine ?

I've looked into the documentation and I didn't find the cases that will
bring to the use of Unix-Sockets or Tcpip-Sockets... When I will receive
the answers, I will write a little text in order to complete the
documentation. :-)

Thanks in advance ! :-)

---------------------------------------
Bruno BAGUETTE - pgsql-ml(at)baguette(dot)net

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Blüm 2003-07-10 11:10:15 Re: IIRC + intervals + and other things
Previous Message Bruno BAGUETTE 2003-07-10 10:44:48 What about a comp.databases.postgresql usenet newsgroup ???