Use Automatic (Delay Start) if PSQL Engine Does not Start After Server Reboot

Use Automatic (Delay Start) if PSQL Engine Does not Start After Server Reboot

Release Date: 04/25/2025
Version: V7.x & up

Q - There's been a few times recently that, after their server has rebooted (either from patching or just routine maintenance), PSQL Engine does not start automatically.  As a result, Elliott doesn't work after. Namely, the two Pervasive SQL services: "Actian PSQL Relational Engine" and "Actian PSQL Transactional Engine" do not start up; they hang in "Start Pending" status. In both cases, the reboots happened around 3AM, and the service was still hung when they started work around 8AM. I was able to reboot the server to bring things back up, but it's obviously disruptive for them to come in and have things not work. Is there any way we can troubleshoot this, to ensure it doesn't happen again? Thank you!

A - Bring up services and change your "Actian PSQL Relational Engine" and "Actian PSQL Transactional Engine" Startup type from "Automatic" to “Automatic (Delayed Start)” to see if that solve your problem.  See sample screen below:



In PSQL 15, the engine has the name changed to Actian Zen 15. In that case, find the services "Actian Zen Enterprise Server" instead.

EMK

    • Related Articles

    • After Server Reboot, Elliott Stopped Working Due to PSQL Engines Not Starting

      Release Date: 08/09/2022 Version: All Q - Our server has been rebooted for maintenance. Since the eboot, none of the Elliott users can use Elliott Business Software. A - This can happen if PSQL services did not start after the server reboot. We have ...

    • A Case Where PSQL 13 Client Is Not Compatible with PSQL 15 Server

      Release Date: 02/04/2025 Version: 8.6 Do Users Need to Upgrade to PSQL 15 Client When Upgrading PSQL Server? We were often asked in the past if our users should upgrade their PSQL 13 client when they upgrade to the PSQL 15 server. In our past ...

    • Do I Need to Change PSQL Server Engine Default Parameters After Installing It?

      Q - I am installing a PSQL server engine for my client. Do I need to change any PSQL parameters after the installation? A - Generally speaking, you don't need to change PSQL parameters after the installation. There are two optional changes you can ...

    • Configure PSQL Server Memory Usage

      Version: Any Release Date: 12/17/2021 Q - Can you tell us why PSQL process is taking up so much memory? Is there anything we can do? See sample screen below: A - PSQL server by default can take up about 60ish% of the server memory. This is ...

    • Actian PSQL Not Started Automatically After Server Reboot

      Release Date: 12/14/2017 Q - I restarted the server and for whatever reason the relational and transactional engines do not start, even though they are set to automatic. Have any idea why this is happening? A - Go to PSQL services –properties -- and ...