Post-installation requirements for NetBackup for PostgreSQL Agent
After you install
(Windows) Configure the NetBackup for PostgreSQL Agent to run with administrative privileges.
(Windows) Add the NetBackup
bindirectory to the PATH user environment variable.(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.Note:
Ensure that you update the PGSQL_LIB_INSTALL_PATH parameter in the
nbpgsql.confwith the absolute path of the symbolic link.(Linux) The user of the agent is a superuser 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.