Surf the Dream A discourse of links and articles from Justin Avery

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;”

Surf the Dream is a blog that has been running since the mid 2000's when it started on BlogSpot. Over the years it's been rebranded as justinavery.me (now my resume) and JaveryDesign.com (which now redirects back to this site).

I offer consultation services through Simple Things, produce a range of educational pocket notebooks, write about the Universe and run a responsive design and a RWD Weekly Newsletter