To create the PostgreSQL database backup set you need to open Xopero and run the Backup set wizard by clicking on New backup set button in My backup sets tab.
In the Backup set wizard mark Advanced copy and select PostgreSQL from drop-down list. Don’t forget to define the backup set name.
In the PostgreSQL panel you need to define parameters that are necessary to connect with the database server:
- Address - IP address of the PostgreSQL database server,
- Port - port, on which the database server is listening,
- User - PostgreSQL database username,
- Password - password for user above.
If parameters above are valid, Xopero will connect with the database and list of available databases will be displayed in the Database field. After you choose a database, you can also select schema that will be backed up in the Schema field. If you don’t choose one, all the databases schemas will be backed up.
When you fill all the required fields, click Test connection to verify connection with the database.
If you choose to edit Connection String, you have to replace *** next to the Password parameter.
Before you finish, define Temporary directory, which is a folder, where database dump will be made to. Click Save to create new backup set.