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.
With this data source type you can use any PostgreSQL backup tool (e.g. pg_basebackup, Barman, pgBackRest) to transfer the data to the Database Lab Engine instance.
To set up it you need to use following jobs:
Copy the contents of configuration example
config.example.physical_generic.yml from the Database Lab repository to
~/.dblab/server.yml. For demo purposes we've made example based on
pg_basebackup tool, but you can use any tool suitable for the task. Check 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, based on your tool
- Set PostgreSQL commands in
command: defines the command to restore data using a custom tool
restore_command: defines the PostgreSQL
restore_commandconfiguration option to refresh data
- Set a proper version in Postgres Docker images tags (change the images itself only if you know what are you doing):