Mike, if there are more than two units in the cluster, I'm not sure how to adjust the following. Hopefully Sophos Support already has fixed this.
To rebuild the SMTP PostgreSQL database:
/var/mdw/scripts/smtp stop
dropdb -U postgres smtp
createdb -U postgres smtp
/var/mdw/scripts/smtp start
EDIT 2016-07-12 - changed line 3 to createdb which is new standard
From the command line, you then need to get to the Slave: ha_utils ssh
And then, rebuild the database there as above.
Please let us know the result and anything different that Support did.
Cheers - Bob
Mike, if there are more than two units in the cluster, I'm not sure how to adjust the following. Hopefully Sophos Support already has fixed this.
To rebuild the SMTP PostgreSQL database:
/var/mdw/scripts/smtp stop
dropdb -U postgres smtp
createdb -U postgres smtp
/var/mdw/scripts/smtp start
EDIT 2016-07-12 - changed line 3 to createdb which is new standard
From the command line, you then need to get to the Slave: ha_utils ssh
And then, rebuild the database there as above.
Please let us know the result and anything different that Support did.
Cheers - Bob