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