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