Skip to main content

Brainspace

PostgreSQL Update
  • Upgrading beyond Brainspace 6.5 means an upgrade to PostgreSQL from 9.6 to 13.4.

    • With this upgrade a new pg_hba.conf file gets created in /var/lib/pgsql/13/data/ and we do not copy over the information from the original one in /var/lib/pgsql/9.6/data/.

    • You should still see files in /var/lib/pgsql/9.6/data/ so you can see how the entries for these two servers are listed in the pg_hba.conf file.

    • After the upgrade completes you can add in the entries for the Analytics and On-Demand Analytics to the /var/lib/pgsql/13/data/pg_hba.conf file.

    • You will need to restart postgres with systemctl restart postgresql-13.

    • It is HIGHLY recommend stopping the platform service first with systemctl stop brainspace-platform, restarting postgres, then starting the platform with systemctl start brainspace-platform.