Postgresql fails due to use of utf8mb4 default encoding

[Ramblurr]

When specifying a postgresql connection uri like postgres://username:password@host/dbname

The migrations fail with the (server side error):

postgres[1748124]: [1748124] ERROR:  invalid value for parameter "client_encoding": "utf8mb4"

Changing the uri to postgres://username:password@host/dbname?charset=UTF-8 is a workaround to this problem, but since utf8mb4 isn't a valid encoding type for postgres, it shouldn't be necessary.

[tchapi]

Hi @Ramblurr

Good catch! The default only works for mySQL but I think that the encoding should be passed in the connection string every time, so we might want to remove it altogether so the error message is clearer

I'll do that soon

[Ramblurr]

It's interesting because the charset query parameter isn't a valid Postgres URI param. This seems to align with some troubles I had using a valid Postgres URI that doctrine complained about.

I suppose under the hood doctrine is parsing the URI and rebuilding it?

[tchapi]

Done in 7b50e1b — can you confirm it fixes your error?

[Ramblurr]

Thanks for the quick turnaround, I'll test this today.

[tchapi]

Is it all good on your side @Ramblurr? I'll probably release in the weekend

Thanks!

[tchapi]

Gentle ping @Ramblurr on this one 🙏🏼 thanks

[Ramblurr]

Can confirm postgresql is working without manually setting ?charset=UTF-8 in the url now. Thanks!