Steps to reproduce the issue

Install Joomla 4 with a Postgres database server
Login to Joomla admin
Attempt to logout.

Expected result

No errors. Session destroyed correctly. Now back at the login screen.

Actual result

System information (as much as possible)

Postgres

Additional comments

I believe this is a release blocker, because if this was a mysql issue, and no one could cleanly logout from Joomla admin, then that would for sure be a release blocker and as Joomla advertises itself as being compatible with pgsql then it should be no difference and this should be a major issue to resolve quickly.

Unfortunately Ive not worked on pgsql since my days working at Skype.com and even then I did not really understand it :-( so need someone that does to correctly convert the session id to a string

Discovered by @alikon white testing a redis session issue here joomla-framework/session#51 (comment) but the redis part is totally unconnected to this issue.