PostgreSQL Requirements for Salesforce

You can store your Salesforce data in a PostgreSQL database that you can access from the internal network. Configure a database if you need a local copy of the Salesforce data or if you want to use any of the following features:

  • Record-level restores
  • Restore to the Salesforce cloud
  • Sandbox seeding
  • Object comparisons

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.

Connection Information

The Commvault Salesforce application connects to a database with default options such as connection timeout, host, instance, and so on. If your setup requires additional connection properties, configure the sf_dbConnectionProperties additional setting.

Database Support and Requirements

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.

Amazon RDS PostgreSQL Server

You can use an Amazon RDS PostgreSQL server instance for backup and restore operations if you can access the Amazon RDS instance from your internal network.

Last modified: 6/5/2020 1:55:17 PM