Performing database name 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:
Table: The postgres.conf parameters to enable WAL archiving
Parameters | Description |
|---|---|
wal_level | This parameter determines how much information is written to the WAL files. |
archive_mode | This parameter enables the archive mode so that the WAL logs get stored in the archive directory using the archive_command. |
archive_timeout | This parameter sets the number of seconds after which the log file segment switches to a new segment. |
statement_timeout | This parameter aborts any statement that takes more than the set number of milliseconds. |
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.