What is the RSA process for upgrading postgresql from 8.4.13 to 9.1 on the SA Server.

[RSAAdmin]

RSA has shipped CentOS6 with the Security Analytics Instance.  This version comes with Postgresql 8.4.13.  RSA has just released SA 10.2 Service Pack2 as an upgrade.  The upgrade contains an rpm "rsaMalwareDevice-10.2.5.5-0.86_64.rpm"  this rpm fails with a dependency over postgresql91-server.  However, RSA has not provided any means to perform this upgrade over postgresql.  Are we supposed to manually perform this or does RSA have an official process to:

1) back up the old DB

2) upgrade the new DB

3) Initialize the new DB

4) migrate any data

5) Start using the new DB

Installing postgresql92-server did not have any affect and this prevents the user from using the free version of Malware.

Thalesdog

[Anonymous · Accepted solution]

On the SA Server you should use the "rsaMalwareDeviceCoLo-10.2.5.5-0.x86_64" package. The "rsaMalwareDevice-10.2.5.5-0.x86_64" package is for the dedicated Malware Analysis appliance, not the SA Server.

[RSAAdmin]

Excellent, thank you!