Table of Contents

Search

  1. Preface
  2. Introducing Administrator
  3. Organizations
  4. Licenses
  5. Ecosystem single sign-on
  6. SAML single sign-on
  7. Metering
  8. Source control and service upgrade settings
  9. Users and user groups
  10. User roles
  11. Permissions
  12. Runtime environments
  13. Serverless runtime environments
  14. Secure Agent services
  15. Secure Agent installation
  16. Schedules
  17. Bundle management
  18. Event monitoring
  19. File transfer
  20. Troubleshooting

Administrator

Administrator

Resetting transaction logs on Windows

Resetting transaction logs on Windows

If the PostgreSQL server does not start because of corruption of the control information, use the command
pg_resetxlog.exe
to reset the control information.
To reset the PostgreSQL database control information, perform the following steps:
  1. Go to
    <Secure Agent installation directory>\apps\process-engine\data\db\postgresql-windows-x64-binaries\pgsql\bin
    .
  2. Run the following command:
    pg_resetxlog.exe -D <path to postgreSQL data directory>
For example, you reset transactions logs in the 'Data' directory if you run the following command:
pg_resetxlog.exe -D "C:\postgre\apps\process-engine\data\PostGreSql\Data"


Updated October 29, 2020