External Postges - PG Extension Issue
Error:
If cxs who are using external postgres(not bundled postgres) faces below error,
1. Migration fails with "Upgrade halted. Please create postgres extension pg_trgm and try again" error. (or)
2. Start-up fails with "Application startup halted. Please create postgres extension pg_trgm and try again" error.
Solution:
Issue is due to unavailability of needed postgres extension. Ask cx to follow below steps to resolve this.
1. Ask cx to start the DB server using startDB.sh or startDB.bat and connect to postgres as superuser. (Username: Postgres and Password: <Super User Password>)
2. Ask cx to execute below queries
CREATE EXTENSION IF NOT EXISTS "pg_stat_statements";
CREATE EXTENSION IF NOT EXISTS "pg_trgm";
3. Ask cx to execute below command in pgsql server and ensure whether pg_stat_statements and pg_trgm extensions are listed in the output.
\dx
4. Ask cx to stop the DB server using stopDB.sh or stopDB.bat and redo the migration/start-up again.
New to ADSelfService Plus?
Related Articles
How to connect to external postgres(external DB)
1. From the postgres installed path navigate to bin folder and open a command prompt 2. Execute the command --> pg_ctl -D "C:\Program Files\PostgreSQL\10\data" start (Postgres server gets started) 3. Connect to DB using the command-->psql -U postgres ...How to Connect External Postgres
Install a External Postgres such that the version of that postgres is currently in the series of inbuilt postgres of our Application. Say for example, In Servicedeskplus Application version 14010, which has postgres version 10.21, then you should ...Unable to start the application due to Pgsql privilege issue
ISSUE: Application does not start via both services and command prompt. ERROR TRACE: Serverout: [16:26:36:443]|[05-10-2023]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[SEVERE]|[27]: Exception occurred while obtaining mode of the database| ...Basic Performance Issues RCA On Postgres DB Cx
Whenever cx faces slowness in PG SQL Setup, below are the first step of actions to check and proceed based on our previous performance tickets. 1. Antivirus are main cause of slowness, high CPU, and memory consumption of PGSQL in many cx tickets. ...How to resolve Connectivity issues with Postgresql Database from our product?
Log Traces Feb 20, 2024 6:40:00 PM [SYSERR] [INFO] : java.sql.SQLException: java.lang.Exception: Exception during getConnection from pool Exception occurred during get connection from datasource Nov 15, 2023 1:29:10 PM [SYSERR] [INFO] : Caused by: ...