Failed to start session after migrating from mysql to postgreSQL

[leprof776]

Hi,

I'm moving Joomla 3.9 to a new server and i'm migrating the mysql database v5.7.9 to postgreSQL v13 because it's a requirement of my client.
I used pgLoader to migrate from mysql to postgresql. I think the migration is fine. I can connect with the psql tool to my new postgreSQL database.
I only changed the property $dbtype with the new value 'pgsql' (before it was 'pdomysql') in the configuration.php file. I kept the same database name, login and pwd to facilitate the migration.

But unfortunately, when I access to http://localhost/mysite/administrator/index.php, I get the following error :

Warning: session_start(): Failed to read session data: user (path: ) in /var/www/html/mysite/libraries/joomla/session/handler/native.php on line 260
Error: Failed to start application: Failed to start the session

The apache log file get the same error message.

Is there something I have to check when we do a database migration ?

Anay help would be appreciate.

Kind regards,

[gws]

Sounds like the session path is not writeable.run the FPA and post the results here.
Read the docs first https://forumpostassistant.github.io/docs/

[Webdongle]

If you edited the configuration.php file then you could have a blank line or hidden char. Or perhaps you edited it with non plain text editor?