Billing Postgres

Policy

{
  "id": "pol-billing-db",
  "environmentId": "env-billing-prod",
  "name": "billing-default",
  "enabled": true,
  "fullBackupCron": "15 1 * * *",
  "criticalTableBackupCron": "15 */4 * * *",
  "retention": {
    "fullBackups": {
      "keepLatest": 10,
      "keepDays": 21,
      "daily": 10,
      "weekly": 6,
      "monthly": 3,
      "minSafeRestorePoints": 2
    },
    "criticalBackups": {
      "keepLatest": 16,
      "keepDays": 7
    }
  },
  "restoreTestSchedule": {
    "enabled": true,
    "cron": "45 3 * * *",
    "keyTables": [
      "public.invoices",
      "public.payments"
    ],
    "nonZeroRowCountTables": [
      "public.invoices"
    ],
    "customSqlChecks": [
      "select count(*) > 0 from public.invoices"
    ]
  },
  "criticalTables": [
    {
      "table": "public.invoices",
      "strategy": "incremental_updated_at",
      "updatedAtColumn": "updated_at",
      "onIncompatibleStrategy": "full_table"
    },
    {
      "table": "public.payments",
      "strategy": "full_table"
    }
  ],
  "artifactCompression": {
    "algorithm": "zstd"
  },
  "createdAt": "2026-03-30T00:00:00.000Z",
  "updatedAt": "2026-03-30T00:00:00.000Z"
}

Recent Runs

Recent Restore Tests

Recent Artifacts

Recent Signals