Product Requirements Ubuntu 20.04 or higher Manually installing PostgreSQL 17 Remove any installed EM server if existed Installing PostgreSQL Update Ubuntu repository list sudo apt-get updatesudo apt-get upgrade Install PostgreSQL 17 Note: Ensure that the line is `local all postgres trust`. Sometimes you would need to allow access via TCP/IP in the pg_hba.conf file Creating… Continue reading Fresh Install Enterprise Manager 24.12 on Linux
Tag: PostgreSQL
Can I Update My PostgreSQL Database?
Only the version of PostgreSQL installed by the Enterprise Manager installer is supported. <br> 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… Continue reading Can I Update My PostgreSQL Database?
EM Postgre to SQL Database Move
Although 3rd party instructions may exist for this process, converting from Postgre to MS SQL is currently not recommended or supported.
PostgreSQL 9.6 End of Life
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… Continue reading PostgreSQL 9.6 End of Life
Postgresql will not install with spaces in username
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.
ESM attempts to install postgresql even if it’s already installed
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 handRun… Continue reading ESM attempts to install postgresql even if it’s already installed
ESM: Moving the PostgreSQL database location
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. <br> 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… Continue reading ESM: Moving the PostgreSQL database location