Setting up external storage for the Postgres database
If you are using the internal Postgres database and need more storage, you can use a network file system to link to external Postgres database.
Before you begin
Take a
snapshot of the virtual appliance before you move the Postgres database to a Network File System.
You can use the snapshot to recover from configuration errors, or if you need to restore the
internal Postgres database later.
Note: If you revert to the internal Postgres database, the snapshot
does not include any data that was added to the NFS database. You must explicitly take the database
backup on the NFS database and restore it to the internal database. Refer to Postgres documentation
for information about how to back up and restore the database.
About this task
This task must be performed on the master Postgres database on a primary node. No business operations can take place during the move to NFS. The time that is needed for the move depends on the size of the database.
Procedure
- Ensure that all changes are synchronized across the nodes.
- Click .
- Select the database to activate the options.
- Click .
- Select the NFS mount point.
- Click Save Configuration.
- Synchronize the nodes. See Synchronizing a member node with a primary node.
Results
- Data is stored externally through the NFS mount point.
- Replication is disabled.
- Move to NFS is disabled.
- The slave database is removed from the Postgres Management table.