Data source: WAL-G
info
As the first step, you need to set up a machine for Database Lab Engine instance. See the guide Set up a machine for the Database Lab Engine.
#
Configuration#
JobsIn order to set up Database Lab Engine to automatically get the data from database using WAL-G archival restoration tool you need to use following jobs:
#
OptionsCopy the contents of configuration example config.example.physical_walg.yml
from the Database Lab repository to ~/.dblab/server.yml
and update the following options:
- Set secure
server:verificationToken
, it will be used to authorize API requests to the Engine - Set connection options in
physicalRestore:options:envs
:- Use WAL-G environment variables to configure the job, see the WAL-G configuration reference
- Set WAL-G settings in
physicalRestore:options:walg
:backupName
- defines the backup name to restore
- Set a proper version in Postgres Docker images tags (change the images itself only if you know what are you doing):
provision:options:dockerImage
retrieval:spec:physicalRestore:options:dockerImage
retrieval:spec:physicalSnapshot:options:promotion:dockerImage
#
Run Database Lab Enginetip
Use Docker volumes to make credential files available to WAL-G. For example: --volume ~/.dblab/sa.json:/home/dblab/sa.json
.
#
Restart in the case of failurenote
This page is unfinished. Reach out to the Postgres.ai team to learn more.