Test the Database Lab Engine (DLE) with PostgreSQL 9.5 (EOL)
Postgres image: postgresai/extended-postgres:9.5
DLE config:
server:
verificationToken: "secret_token"
port: 2345
embeddedUI:
enabled: true
dockerImage: "postgresai/ce-ui:latest"
host: ""
port: 2346
global:
engine: postgres
debug: true
database:
username: postgres
dbname: test
telemetry:
enabled: false
url: "https://postgres.ai/api/general"
poolManager:
mountDir: /var/lib/dblab
dataSubDir: data
clonesMountSubDir: clones
socketSubDir: sockets
observerSubDir: observer
preSnapshotSuffix: "_pre"
selectedPool: ""
databaseContainer: &db_container
dockerImage: "postgresai/extended-postgres:9.5"
containerConfig:
"shm-size": 1gb # default is 64mb, which is often not enough
databaseConfigs: &db_configs
configs:
shared_buffers: 500MB
shared_preload_libraries: "pg_stat_statements, pg_stat_kcache, auto_explain"
work_mem: "100MB"
provision:
!!merge <<: *db_container
portPool:
from: 6000
to: 6100
useSudo: false
keepUserPasswords: false
retrieval:
refresh:
timetable: "*/10 * * * *"
jobs:
- logicalDump
- logicalRestore
- logicalSnapshot
spec:
logicalDump:
options:
!!merge <<: *db_container
dumpLocation: "/var/lib/dblab/dblab_pool/dump"
source:
type: remote
connection:
dbname: test
host: db.scshghslgzunteqlufuy.supabase.co
port: 5432
username: postgres
password: postgres-pass
databases:
test: {}
parallelJobs: 2
logicalRestore:
options:
!!merge <<: *db_container
dumpLocation: "/var/lib/dblab/dblab_pool/dump"
parallelJobs: 4
forceInit: true
!!merge <<: *db_configs
queryPreprocessing:
queryPath: ""
maxParallelWorkers: 2
inline: ""
logicalSnapshot:
options:
!!merge <<: *db_configs
preprocessingScript: ""
dataPatching:
!!merge <<: *db_container
queryPreprocessing:
queryPath: ""
maxParallelWorkers: 2
inline: ""
cloning:
accessHost: "localhost"
maxIdleMinutes: 120
Edited by Vitaliy Kukharik