PostgreSQL service will not start

Triofox uses PostgreSQL as the database. The service is gladpostgresrv. And Triofox server agent uses PostgreSQL as the task database. Here, the service is gladpostgre.

On rare occasion the PostgreSQL service will fail to start. If PostgreSQL fails on Triofox server, the web portal will be unavailable. If it fails on Server Agent installation, can't open server agent management console or start the server agent 'Triofox Server Agent Access Service'.

In case like this, try to manually start the PostgreSQL service and check the event viewer.

. You may see errors referencing the replication checkpoint like this:

In case like this, please go to the folder C:\CSPDBRoot\pg_logical (on Triofox installation) or C:\ProgramData\Cloud Server Agent\pg_logical (on server agent installation).

Here, rename the file replorigin_checkpoint to replorigin_checkpoint.bak

Restart the PostgreSQL service after the file is renamed. A new file will be created.

On the service is up, on Triofox server, restart IIS. Verify the login on Triofox web portal.

On Server Agent machine, restart 'Triofox Server Agent Access Service'. After that, open server agent management console. It should open.

. If you see other error, please take a screenshot and share the error with ticket@triofox.com.