raf via Postfix-users: > On Fri, Oct 25, 2024 at 11:46:38AM +1100, Viktor Dukhovni via Postfix-users > <postfix-users@postfix.org> wrote: > > > On Thu, Oct 24, 2024 at 07:35:26PM -0400, Wietse Venema via Postfix-users > > wrote: > > > > > > Note, my cursory look at the code suggests that URI connection strings > > > > MUST specify a database name, the required "dbname" parameter is never > > > > used to augment the URI, even if it appears to not include the required > > > > databasename path component. > > > At least for unix-domain socket connections, Postgres appears to > > default a database equal to the username attempting the connection. > > The same is true over tcp.
I suppose that the PostgreSQL client library code is looking up the username, and using that as the default database name for a connection URI. Viktor, I don't think that Postfix's pgsql client cares what URI scheme is being used, as long as the PostgreSQL client library finds it acceptable. So we can simplify the text to: PGSQL PARAMETERS hosts The hosts that Postfix will try to connect to and query from. Besides a PostgreSQL connection URI, this setting supports the historical forms unix:/pathname for UNIX-domain sockets and [...] Wietse _______________________________________________ Postfix-users mailing list -- postfix-users@postfix.org To unsubscribe send an email to postfix-users-le...@postfix.org