471,075 Members | 1,272 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

unix_socket

I'm trying to configure postfix to use the postgres database for lookups.

Since I have a localhost based server, I was going to use unix_sockets.

The postgres docs call for only a /directory.

unix_socket_directory (string)

Specifies the directory of the Unix-domain socket on which the
server is to listen for connections from client applications. The
default is normally /tmp, but can be changed at build time.

The postfix docs call for a /directory/name.

inet: for TCP connections (default). Example:
hosts = host1.some.domain host2.some.domain
hosts = unix:/file/name

--------------
How do I get this sorted out so that I can make a unix connection?
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
2 1930
Tom Allison <ta******@tacocat.net> writes:
I'm trying to configure postfix to use the postgres database for lookups.
Since I have a localhost based server, I was going to use unix_sockets. The postfix docs call for a /directory/name.
inet: for TCP connections (default). Example:
hosts = host1.some.domain host2.some.domain
hosts = unix:/file/name


I suspect you want to say unix:/tmp/.s.PGSQL.5432
(adjust if you are using a nonstandard port number)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #2
Tom Allison wrote:
I'm trying to configure postfix to use the postgres database for lookups.

Since I have a localhost based server, I was going to use unix_sockets.

The postgres docs call for only a /directory.

unix_socket_directory (string)

Specifies the directory of the Unix-domain socket on which the
server is to listen for connections from client applications. The
default is normally /tmp, but can be changed at build time.


I found that my Debian installation had unix_socket_directory built to
unix_socket_directory=''
and in order to use sockets, you have to explicitly call it out.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Daniel Baggott | last post: by
reply views Thread by G Gill | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.