Configuring the Archive Log Directory for PostgreSQL

Archive log files are stored in the Archive Log directory. Ensure to follow the below checkpoints before running the IntelliSnap PostgreSQL FS backup.

  • Specify the Archive log directory path in the postgresql.conf file prior to performing the PostgreSQL FS backup. Make sure that this path does not point to pg_log and pg_xlog directories.

    archive_command = 'cp %p /opt/wal/%f' #UNIX
    archive_command = 'copy "%p" "D:\\PostgreSQL\\wal\\%f"' #Windows

  • From PostgreSQL 8.3 version onwards, use the following command to turn on the archive_mode. This feature is not supported for PostgreSQL 8.2 and earlier versions.

    archive_mode = on

  • From PostgreSQL 9.x.x version onwards, use the following configuration.

    Set wal_level = archive instead of default wal_level = minimal

Last modified: 6/5/2019 6:17:19 AM