Support customOptions for logicalDump (pg_dump) and logicalRestore (pg_restore) jobs:
customOptions
to logicalDump
(including immediateRestore
) and logicalRestore
jobsImplementation features:
logicalRestore:
options:
customOptions:
- "--verbose"
- "--jobs=2"
parallelJobs
, ...), but consider them deprecated (and then probably remove later) to have a single way of dump/restore customizationimmediateRestore
because it doesn't use them and it will take extra effort to detect if the section is enabledGET /admin/config
{
"databaseConfigs": {
"configs": {
"shared_buffers": "256MB",
"shared_preload_libraries": "pg_stat_statements, auto_explain, pgaudit, logerrors, pg_stat_kcache"
}
},
"databaseContainer": {
"dockerImage": "postgresai/extended-postgres:14"
},
"global": {
"debug": true
},
"retrieval": {
"refresh": {
"timetable": "0 * * * *"
},
"spec": {
"logicalDump": {
"options": {
"customOptions": [
"--exclude-schema=rdsdms"
],
"databases": {},
"parallelJobs": 1,
"source": {
"connection": {
"dbname": "test",
"host": "172.17.0.2",
"port": 5432,
"username": "postgres"
}
}
}
},
"logicalRestore": {
"options": {
"customOptions": [
"--no-privileges",
"--no-owner",
"--exit-on-error"
],
"parallelJobs": 1
}
}
}
}
}
POST /admin/config has the same body, respectively
Closes #361 (closed)