| 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: | Whole Thread | Raw Message | 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
| 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 ??? |