Query Executor Tool for PostGres
This tool is designed to execute queries in the customer environment by connecting the database by reading the database configuration file. We need to enter the query that we require to execute in queryToExecute.txt file. We can enter multiple queries separated by a new line.
Note :
- This tool is only tested in the Postgres environment.
- This tool is not designed for executing sensitive queries in cx environment.
- Please take a backup of the database before running this tool.
How to use the Tool?
- Download the attached QueryExecutor.zip and extract it on the <servicedeskplus_home> directory. A folder will be created at <servicedeskplus_home>\QueryExecutor.
- Start the ServiceDeskPlus Application service / Database Server.
- Navigate into <servicedeskplus_home>\QueryExecutor folder
- Replace the queryToExecute.txt with the input file that you have provided.
- Execute run.bat or .sh in the same folder, after these steps.
- Stop the application server / Database Server.
Share the queryExecutor.log file generated in the <servicedeskplus_home>\QueryExecutor folder to analyse further.
New to ADSelfService Plus?
Related Articles
Query Executor Tool for Postgres
Overview: A query executor tool for PostgreSQL that allows for query execution without a direct database connection enhances security and flexibility while collaborating on query testing without the need for each team member to have direct database ...Remote read only access to database for Postgres customers
Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to allow ...Upgrade failure when migrating privileges for removed functions
LOG Trace : 03.08.2023 12:50:36 [com.zoho.postgres.migrate.DumpMigration] [SCHWERWIEGEND] : Problem during upgrade.com.zoho.postgres.exception.MigrationFailureException: Restoration failed for PRE_DATA at ...How to Connect External Postgres
To install an external PostgreSQL server, ensure the PostgreSQL version matches the inbuilt PostgreSQL version series of the ServiceDesk Plus application. For example: If ServiceDesk Plus version is 14010 with PostgreSQL version 10.21, install an ...Migration failure for Postgres Database with a blank space in it
Trace : \ManageEngine\ServiceDesk\Patch\AdventNet_ManageEngine_ServiceDesk_Plus-14.2.0-SP-1.0.0\SERVICEDESK\PreInstall\pg_migrate\pgsql_old\bin\pg_dumpall.exe", -U, postgres, -p, 65433, -h, 127.0.0.1, -r, -w, |, ...