A new documentation is available for Squash TM 2.0 and later versions, check it here
Create a new database with UTF8 encoding for Squash TM, and grant all rights on this database for a user:
CREATE DATABASE "squashtm" WITH ENCODING='UTF8';
CREATE USER "squash-tm" WITH PASSWORD 'initial_pw';
GRANT ALL PRIVILEGES ON DATABASE "squashtm" TO "squash-tm";
Warning
Deleting large objects (attachments) in PostgreSQL does not delete data (only the link to the data).
To clean your database of useless large object please use vacuumlo (See PostgreSQL documentation for usage).
Warning
While creating the database, you might get this message, depending on your configuration :
ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT: Use the same encoding as in the template database, or use template0 as template.
To overcome this problem, you might try to use this command :
CREATE DATABASE "squashtm" WITH ENCODING='UTF8' TEMPLATE template0;