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 PostgreSQL server must meet the following requirements:
- The PostgreSQL version must be V9.3 or higher.
- The PostgreSQL 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 PostgreSQL server so the disk is not filled with transaction logs during Salesforce backup operations.
- For operations that restore data from the PostgreSQL database, such as record-level restores, the database must be accessible from the Web Server.
Last modified: 3/25/2019 7:36:41 PM