[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postfix-devel
Subject:    Re: postfix-pgsql to use connection string
From:       Magosányi, Árpád <m4gw4s () gmail ! com>
Date:       2016-12-11 19:58:35
Message-ID: 6ac5ca0e-c9c9-051f-e06c-4c2cf2ce663f () gmail ! com
[Download RAW message or body]

On 12/11/2016 07:58 PM, Wietse Venema wrote:
> Magos?nyi, ?rp?d:
>> Hi,
>>
>> I am using postfix-pgsql with ssl authentication. Therefore I need to
>> provide a connection string for postgres connections. A patch is
>> attached to do so.
>>
>> See https://bugs.launchpad.net/ubuntu/+source/postfix/+bug/1553928 for
>> more details.
> Thanks for the code. Can you document the "postgresql:" prefix in
> proto/pgsql_table, i.e. the source code for the pgsql_table(5)
> manpage?
>
> 	Wietse

Here you are.

Is there a gthub repo? Sending pull requests is less last millenium.

--- pgsql_table.orig    2016-12-11 20:53:49.030543785 +0100
+++ pgsql_table    2016-12-11 20:56:44.386592266 +0100
@@ -89,10 +89,12 @@
 # .IP "\fBhosts\fR"
 #    The hosts that Postfix will try to connect to and query from.
 #    Specify \fIunix:\fR for UNIX-domain sockets, \fIinet:\fR for TCP
-#    connections (default).  Example:
+#    connections (default), of \fIpostgresql:\fR if you use a connection
+#    string.  Example:
 # .nf
 #        hosts = host1.some.domain host2.some.domain:port
 #        hosts = unix:/file/name
+#        hosts =
postgresql://username@hostame.org/tablename?sslmode=require
 # .fi
 #
 #    The hosts are tried in random order, with all connections over

[prev in list] [next in list] [prev in thread] [next in thread]