Unknown macro: {composition-setup}

This document provides information on configuring an external database.

Database Selection

Production instances of Confluence should use an external database. The default hSQL database has a risk of unrecoverable data loss due to not being transaction-safe.

Corruption is occassionally encountered after sudden power loss and can usually be corrected using this data recovery procedure. hSQL is still suitable for evaluation purposes, but the risk can only be eliminated by switching databases. External databases may also provide superior speed and scalability. Below is more information on selecting an external database.

Database Setup

Setup instructions are shown below; click on a database to review the setup guide and any known issues.

Unknown macro: {toggle-cloak}

MySQL

Unknown macro: {cloak}
Error formatting macro: contentbylabel: com.atlassian.confluence.api.service.exceptions.BadRequestException: Could not parse cql : null
Unknown macro: {toggle-cloak}

PostgreSQL

Unknown macro: {cloak}
Error formatting macro: contentbylabel: com.atlassian.confluence.api.service.exceptions.BadRequestException: Could not parse cql : null
Unknown macro: {toggle-cloak}

Oracle

Unknown macro: {cloak}
Error formatting macro: contentbylabel: com.atlassian.confluence.api.service.exceptions.BadRequestException: Could not parse cql : null
Unknown macro: {toggle-cloak}

SQL Server

Unknown macro: {cloak}
Error formatting macro: contentbylabel: com.atlassian.confluence.api.service.exceptions.BadRequestException: Could not parse cql : null
Unknown macro: {toggle-cloak}

DB2

Unknown macro: {cloak}
Error formatting macro: contentbylabel: com.atlassian.confluence.api.service.exceptions.BadRequestException: Could not parse cql : null
Unknown macro: {toggle-cloak}

Sybase Database

Unknown macro: {cloak}
Error formatting macro: contentbylabel: com.atlassian.confluence.api.service.exceptions.BadRequestException: Could not parse cql : null

Other databases should use Database Setup For Any External Database.

Optimise Database Performance

To improve database responsiveness:

Database Troubleshooting

For solving database-related problems:

Obtain technical support from Troubleshooting & Technical Support

Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.