Performing backups
This topic lists the prerequisites for the backup, describes the procedure to run a backup, and the information to schedule the backup from NetBackup.
Before you run the backup, ensure that you meet the following prerequisites:
Create the
archivedirdirectory and then set the following parameters in thepostgresql.conffile:wal_level = archive
archive_mode = on
archive_timeout =0
statement_timeout=0
Note:
Ensure that you add the time in milliseconds. The recommended time is 30000 milliseconds (30 seconds).
Mention the following changes for archive_command
(Windows)'copy ' "%p" "C:\\archivedir\\%f"'
(Linux) test ! -f <archive_path>/%f && cp %p <archive_path>/%f
(Linux) After creating the
archivedirdirectory, change the group and ownership to PostgreSQL user.Restart the PostgreSQL services.