Adding a PostgreSQL Instance
Add a PostgreSQL instance when you need to manage a database.
Tip: If you have access to more than 10 server groups, use the arrow buttons at the lower-left bottom of the page to page through the server groups.
When you add an instance, the following backup sets are automatically created, each with a default database group:
Before You Begin
- Obtain the PostgreSQL application path and library directory path.
- Obtain the credentials that you use to access the PostgreSQL application.
- Make sure that you have a storage policy to use for log backups.
- Configure the PostgreSQL archive log directory.
For more information, see Configuring the PostgreSQL Archive Log Directory.
- Optional: If you want to use a specific account when you perform backup and restore operations, have the user name and the password.
- From the navigation pane, go to Protect > Databases > DB Instances.
- Click Add instance, and then select PostgreSQL.
The Add PostgreSQL instance dialog box appears.
- From the Server name list, select a server where you want to create the new instance.
- In the Instance Name box, type the PostgreSQL instance name.
- From the Plan list, select a server plan.
- Under Connection details, enter the following information:
- In the Database user box, type the user name to access the PostgreSQL application.
- In the Password box, type the PostgreSQL user account password.
- In the Port box, type the port to open the communication between PostgreSQL Server and the clients.
- In the Maintenance DB box, type the name of a system database which is used as a maintenance database.
- Under PostgreSQL paths, enter the following information:
- In the Binary directory box, type or browse the path to the PostgreSQL application.
- In the Lib directory box, type or browse the path to the library directory for the instance.
For example, /opt/PostgreSQL/9.4/lib.
- In the Archive log directory box, complete one of the following steps:
- On a UNIX client, type the path to the directory where you want to store the archive log files. For example, /opt/wal. Make sure that this path does not point to pg_log and pg_xlog directories.
- On a Windows client, type the path to the directory where you want to store the archive log files.
- Click Add.
The software creates the instance and a default database group for DumpBasedBackupSet and FSBasedBackupSet.
What to Do Next
Create database groups for the data that you want to protect.
Last modified: 8/10/2020 7:03:53 AM