I am currently working on migrating a Postfix instance from using a local
Postgres server to a cloud-hosted one.
I have verified I can connect to the Postgres database using the credentials
and have manually executed the query. So everything is confirmed as ready to go.
So it should be as simple as swapping the `hosts=`, and doing a `reload` right ?
Wrong !
I have this in my main.cf:
relay_recipient_maps = pgsql:${config_directory}/pgsql_relay_recipient_maps.conf
And pgsql_relay_recipient_maps.conf has three lines:
hosts=
dbname=
query=
The *working* internal `hosts=` line looks something like:
hosts=postgresql://myusername:[email protected]/database_name?sslmode=require
So for the cloud provider, I just replaced `internal.server` since the user
account got migrated over retaining the same password.
I get this obscure message:
smtpd[129133]: warning: connect to pgsql server postgres://....(REMOVED FOR
BREVITY)...: local user with ID 109 does not exist?
So I thought ok, maybe I will try the full-fat version, changing "ssl=require"
(which works on manual tests) to "ssl=verify-full&sslrootcert=cert.pem" (the
"cert.pem" being colocated in the postfix config directory, but I tried
full-path too).
But no. The same obscure message:
smtpd[129133]: warning: connect to pgsql server postgres://....(REMOVED FOR
BREVITY)...: local user with ID 109 does not exist?
Any ideas ?????
_______________________________________________
Postfix-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
