Under the Celoxis install directory there is a "data" directory. This contains a variety of information including the documents that you have uploaded into the application. Back up this directory regularly.
You must also back up the database. The command pg_dump -Ft -d < company nickname > [filename] will create a dump file which can be restored using the pg_restore command. Please read the Postgresql administration guide for details.
Postgres also recommends running the command "VACUUM ANALYZE" once in a while. For this you may either connect to the database using psql -d < company nickname > and then run the command OR you can run echo "VACUUM ANALYZE" | psql -d < company nickname > from the command line directly. For details please read Postgresql Administration guide.
For MSSQL and Oracle backup instructions refer to their respective databases.