PostgreSQL Requirements for Salesforce
To have a local copy of the Salesforce data, you can install PostgreSQL on a server. Each Salesforce organization needs a separate database. For example, if you back up two production organizations and one sandbox organization and need a local copy of all three, configure three databases.
The Postgres server must meet the following requirements:
- The Postgres version must be V9.3 or higher.
- The Postgres server host must have free space that is at a minimum equal to double the size of the Salesforce used data storage. This number accounts for the Salesforce data change frequency because the database maintains all versions.
- Best Practice: Disable Write-Ahead Logging (WAL) in the Postgres server so the disk is not filled with transaction logs during Salesforce backup operations.
Last modified: 3/25/2019 7:55:01 PM