Hi everybody,
thanks for answering! :-)
The expansion parameters `%s`, `%u` and `%d` are not working as documented:
You're mistaken. The behaviour is exactly as documented.
Sorry, but where is this documented at
https://www.postfix.org/pgsql_table.5.html ? I see explanations for each
expansion parameter, but I don't see any note that if I pass `%s`, I get
in fact queries with `%s`, `%u` and `%d`.
Is it possible to suppress these additional queries? I.e. just query for
`%s`, and if nothing is found, then fail?
# About the connection string at https://www.postfix.org/pgsql_table.5.html
What problem were you having with that connection string?
* You should add a password.
* You should mention that the entire string needs to be urlencoded (I guess)
* You should use 127.0.0.1 as address, since this is (probably) what
most people need.
* You should explain how options are working. Based on your other
comments, I guess you should write something like:
> Connection options from
https://www.postgresql.org/docs/current/app-psql.html can be appended to
the connection string like that:
.../databasename?sslmode=require&foo=bar
> The following Postfix-options need to be given as separate key and
cannot be appended to the connection string:
idle_interval
retry_interval
...
And this sentence:
Historically, the database client was hard coded to use LATIN1 in an attempt to
disable multibyte character support.
should be change to something like:
> Through Postfix 3.7, the database client was hard coded to use LATIN1...
Cause the existing "This feature is available in Postfix 3.8 and later."
only tells people that they cannot change it in 3.7; while in fact the
other sentence about UTF8 being the default is wrong for 3.7.
# About `dbname`:
We could add a ton of code to parse a postgresql:// URI and find
out if it specifies a database name, but that does not seem right.
Oh, you don't look into the connection string, but just pass it to psql
and see what happens? (Didn't know that...)
Then I would suggest to just make `dbname` not required anymore, and
that's it. Cause when user & password are optional, and dbname is
required, that's a little strange, isn't it?
--
Cheers,
Thomas
_______________________________________________
Postfix-users mailing list -- postfix-users@postfix.org
To unsubscribe send an email to postfix-users-le...@postfix.org
