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
Post-installation requirements for NetBackup
After you install
(Windows) Ensure that the user who is performing backups and restores has administrative privileges.
(Linux) Symbolic link: If a symbolic link does not exists, create
libpq.sothat points tolibpq.so.<n>, where<n>is the PostgreSQL library version. You can create the symbolic link at your chosen directory.For example, if the PostgreSQL library version is 5, then the symbolic link
libpq.sopoints tolibpq.so.5.#ln -s /<pgsql_lib_install_path>/libpq.so.5 libpq.so(Linux) Ensure that the user who is performing backups and restores is a super user or has superuser privileges.
Set the following database user privileges:
Table: User and the privileges
User | Privileges |
|---|---|
Backup | LOCK TABLES, SELECT FILE, RELOAD, SUPER, UPDATE, TRIGGER, SHOW, VIEW, EXECUTE, and EVENT. |
Restore | CREATE, DROP, INDEX, SHUTDOWN, INSERT, ALTER, DELETE, UPDATE, TRIGGER, SUPER, and CREATE VIEW. |
To set the database user privileges, run the following PostgreSQL command:
ALTER USER<db_user> with SUPERUSER
For more information, see PostgreSQL Administrator's Guide.