unix_socket

[Tom Allison]

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

[Tom Lane]

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

[Tom Allison]

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