Clear Mysource Matrix Cache from the Command Line

While upgrading from Mysource Matrix 3.20.2 to 3.22.1 you need to turn off and clear the cache from the system.

Unfortunately, if you are running a large system you may not have the memory allocation to perform the system wide clear cache option that can be found under the System Management – Cache Manager – Clear Cache section in the back end.

There is an easier solution though, and for those that have ssh access to their systems I can say it is a much simpler way to clear mysource matrix cache.

SSH into your system and type the following:

psql -U postgres -d DBNAME -c “TRUNCATE sq_cache;”

Leave a comment

Your email address will not be published. Required fields are marked *