NetBackup™ for PostgreSQL Administrator's Guide
- Introduction to NetBackup for PostgreSQL
- Configuring NetBackup for PostgreSQL
- NetBackup for PostgreSQL backup and restore
- About PostgreSQL backups
- Performing PostgreSQL backups
- Validating the PostgreSQL backups
- Querying the PostgreSQL backups
- Deleting backup information from the NetBackup catalog files
- About PostgreSQL restore
- Performing the PostgreSQL restores
- Redirected restores
- Recovering the restores
- Disaster recovery
- Troubleshooting for PostgreSQL
- Appendix A. NetBackup for PostgreSQL commands and conventions
- Appendix B. NetBackup for PostgreSQL commands
- Index
The postgresql.conf configuration file
The postgresql.conf file contains the parameters that you must set to enable WAL archiving before you run a backup.
Table: The postgres.conf parameters to enable WAL archiving table lists the parameters that you must set to archive the WAL logs.
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. |