Error data base postgresql trying to upgrade

Hi everyone
I’m trying to upgrade OJS from 3.1.2-0 to 3.1.2-4, but when I’m trying to run upgrade tool, I got the next message

[pre-install]
[load: upgrade.xml]
[version: 3.1.2.4]

[code: Installer Installer::checkPhpVersion]
[schema: lib/pkp/xml/schema/common.xml]
ERROR: Upgrade failed: DB: ERROR: no existe el tipo «serial»

When I run with the same tool with check option the message is:
Code version: 3.1.2.4
Database version: 3.1.2.0
Latest version: 3.3.0.11
Database version is older than code version
Run “upgrade.php upgrade” to update

My Sandbox Environment
It’s the same in production
Centos 7
Apache/2.4.6
Postgresql 9.6
PHP 7.4
OJS version installed 3.2.1-0

I don’t know how to solve it, I read that it’s not difficult to upgrade between build versions, in the same article I could know that could be some database changes between minor or major versions, there is someone who has solved it?, any cue will be important for me.

Hi @jarulin

There is an patch to fix this issue to OJS using PGSQL DB, please see it here:

Best,
Israel