Tag: PostgreSQL

Can I Update My PostgreSQL Database?

Post author By Bhargav Atturu
Post date February 5, 2024

Only the version of PostgreSQL installed by the Enterprise Manager installer is supported.

The exacqVision Enterprise Manager application provides a PostgreSQL installation to store Enterprise Manager data by default.

The PostgreSQL Global Development Group may offer application updates that are not yet included within the ExacqVision Enterprise Manager installer. At times, users will seek to upgrade to the very latest version of PostgreSQL.

Updating the PostgreSQL database application independently from Enterprise Manager updates may break your Enterprise Manager operation and/or result in lost data. Changes made between versions of PostgreSQL and Enterprise Manager have not been tested. Only the version of PostgreSQL installed by the Enterprise Manager installer is supported.

Tags PostgreSQL, 18793, Guest, ESM, Enterprise System Manager, Enterprise Manager, Updates

Knowledge Support Support exacqVision Enterprise Categories

EM Postgre to SQL Database Move

Post author By Bhargav Atturu
Post date October 18, 2021

Although 3rd party instructions may exist for this process, converting from Postgre to MS SQL is currently not recommended or supported.

Tags 6469, Guest, Enterprise System Manager, EM, PostgreSQL, SQL Server

Knowledge Support Documentation Support exacqVision Enterprise

PostgreSQL 9.6 End of Life

Post author By Tom Oakes
Post date May 24, 2021

PostgreSQL 9.6 is currently bundle with exacqVision Enterprise Manager. This version will reach end of life in November 2021.

The PostgreSQL Global Development Group will release the final update for 9.6 on November 11, 2021. See their versioning page for details at https://www.postgresql.org/support/versioning/

AWS has announced PostgreSQL 9.6 on will reach end of life on January 31, 2022. See the forum announcement at https://forums.aws.amazon.com/ann.jspa?annID=8512 for more details.

Preparation and testing for a migration to a newer version of PostgreSQL is ongoing and will be bundled in exacqVision Enterprise Manager.

Tags 5635, Guest, Enterprise System Manager, EM, PostgreSQL, Vulnerability

Knowledge Support Support exacqVision Enterprise Categories Products

Postgresql will not install with spaces in username

Post author By Bhargav Atturu
Post date May 5, 2021

Description

The packaged postgresql installer when trying to install ESM, you cannot install it with a username that has spaces.

Also, postgresql requires admin to install properly on the machine. You cannot install with a policy group that does not have sys admin on the machine.

Tags Install Failure, 5245, PostgreSQL, Will Not Install, Level2, Spaces in Username

Knowledge Support Support exacqVision Enterprise Categories Products

ESM attempts to install postgresql even if it’s already installed

Post author By Bhargav Atturu
Post date April 26, 2021

The installer for the following specific version has an option to install postgresql even if it detects a postgresql installation on the machine, however it does not work. It throws an error as it is not able to set the install path correctly.

Tested Version

3.6.0

Platform

Windows

Steps to reproduce

Install postgresql by hand
Run ESM installer, select install postgresql on dialogue popup

Expected result

Installation completes of postgresql

Actual result

Error in trying to install

Introduced Version

r82419

Work Around

Do not attempt to install postgresql if it is already installed.

Tags 4696, Attempts to Install PostgreSQL, ESM, Enterprise System Manager, Enterprise, PostgreSQL, Install, Level2

Knowledge Support Support exacqVision Enterprise Categories Products

ESM: Moving the PostgreSQL database location

Post author By Bhargav Atturu
Post date June 18, 2015

Steps:

When you run the Enterprise System Manager (ESM) installer and select PostgreSQL as the database, it installs the PostgreSQL files at the ESM installation location, except for the data folder that actually contains the database.

By default, the database is installed in c:/Program Files (x86)/postgresql/9.2/data, and the ESM installation directory is C:/exacqVisionESM/PostgreSQL/9.2/, although it’s possible to select a different location during installation.

To move the data folder to the ESM installation location, complete the following steps:

Stop all ESM services: ESMImporter, ESMSendemail, ESMDatarolloff, and ESMWebservice.
Follow the instructions in the following article provided by PostgreSQL: https://wiki.postgresql.org/wiki/Change_the_default_PGDATA_directory_on_Windows
Restart the ESM services that you stopped in step 1.

ESM-Moving-the-PostgreSQL-database-location.pdf

Tags Guest, ESM, Enterprise, PostgreSQL, Database Location, KB-00041-41-210203, 645