4 4 3:PostgreSQL Backup
Granting access to the database
In order for the SEP sesam PostgreSQL Backup module to work correctly, the root user must have access to the database instance.
On modern PostgreSQL setups access can be granted by using the following command:
root@database-system# su - postgres "-c createuser -s root"
This can be verified by listing the available databases on the command line:
root@database-system:~# psql -l
Backing up a PostgreSQL single database
Create a new backup task for the backup of the PostgreSQL server.
- From Main Selection -> Tasks -> By Clients, select PostgreSQL client and click New Backup Task. The New Backup Task window opens.
- Use the browse button to specify the Source and select what you want to back up. By selecting the source, the task type and task name are set automatically.
- Specify the user name (usually postgres instead of root) to access the database: click the tab Options and enter the following in the Backup options (previously Save options) and Restore options field.
- If you want to set encryption, specify OS credentials, consolidate individual tasks under a specific task group, or assign a task to the schedule click the corresponding tabs in the New Backup Task window. Note that other options are not available (pre/post backup and restore commands, compressing data).
- If you want to start the newly created task immediately, right-click the name of the task and click Immediate Start. If you want to create a periodic backup, you have to create a schedule for your backup task: Click New Schedule under Main Selection -> Scheduling -> Schedules and set up a schedule. For more details, see Creating a Schedule.
- Once you have configured a schedule, you must create a new backup event for it. For general information on creating a backup event, see Creating a backup event.
You can also specify different port with -a port=<port_number>, under the tab Options in the Backup options (previously Save options) field.
Click OK to create the task.
|You can also add your backup task to an existing schedule by double-clicking the backup task, selecting the tab Schedules and adding it to one or more schedules. Additionally, you can group your backup tasks to task groups. For details, see Adding a Task to the Task Group.|
You can view the status of your backup jobs by selecting Last Backup State in the Main Selection window. The backup status overview provides detailed information on the last run of backup jobs, including the task name, start and stop time of the last backup, backup level, data size, throughput, assigned media pool, etc.
|As of 4.4.3 Beefalo V2, you can check the details of your backups online by using new Web UI. For details, see SEP sesam Web UI.|