Loading...

Configuring WAL Segment Size for PostgreSQL

For successful incremental backups, it is mandatory that the WAL segment size for PostgreSQL is 16 MB both for Windows and UNIX clients. By default, all the versions of PostgreSQL have 16 MB WAL segment size except for Postgres Plus® Advanced Server version 9.0.

Use the following steps to configure the WAL segment size for Postgres Plus® Advanced Server version 9.0 to 16 MB:

  1. From the CommCell Browser, navigate to Client Computers.
  2. Right-click the client, and then click Properties.
  3. Click Advanced.
  4. Click the Additional Settings tab.
  5. Click Add.
  6. In the Name box, type sWalSegmentSize.

    The Category and Type details will be automatically populated.

  7. In the Value box, type the WAL segment size as 16 MB.
  8. Click OK.

Last modified: 6/5/2019 6:27:20 AM