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
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 ...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| ...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: ...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 ...