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