Billing Postgres

< Back to overview

Project
Billing Postgres
Provider
postgres
Critical Signals
0

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

TypeStatusFinishedError
critical queued - -
critical queued - -
critical queued - -
critical queued - -
critical queued - -
restore_test queued - -
full queued - -
critical queued - -
critical queued - -
critical queued - -
critical queued - -
critical queued - -

Recent Restore Tests

StatusFinishedTarget DBNotes
No restore tests found

Recent Artifacts

KindRemote KeySizeState
No artifacts found

Recent Signals

SeverityCodeSummaryEmitted
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-30T01:15:00.000Z 2026-05-30 01:35:26.96822+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-29T01:15:00.000Z 2026-05-29 01:35:15.24519+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-28T01:15:00.000Z 2026-05-28 01:35:03.560926+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-27T01:15:00.000Z 2026-05-27 01:35:22.741146+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-26T01:15:00.000Z 2026-05-26 01:35:11.661587+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-25T01:15:00.000Z 2026-05-25 01:35:29.031455+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-24T01:15:00.000Z 2026-05-24 01:35:18.3074+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-23T01:15:00.000Z 2026-05-23 01:35:08.395772+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-22T01:15:00.000Z 2026-05-22 01:35:30.760518+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-21T01:15:00.000Z 2026-05-21 01:35:20.566578+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-20T01:15:00.000Z 2026-05-20 01:35:25.474014+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-19T01:15:00.000Z 2026-05-19 01:35:06.114901+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-18T01:15:00.000Z 2026-05-18 01:36:21.973361+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-17T01:15:00.000Z 2026-05-17 01:35:16.608786+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-16T01:15:00.000Z 2026-05-16 01:35:23.023123+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-15T01:15:00.000Z 2026-05-15 01:35:09.032351+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-14T01:15:00.000Z 2026-05-14 01:35:23.032362+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-13T01:15:00.000Z 2026-05-13 01:35:08.064421+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-12T01:15:00.000Z 2026-05-12 01:35:09.386975+00
warning stale_backup_detected stale full backup detected for policy pol-billing-db at 2026-05-11T01:15:00.000Z 2026-05-11 01:35:16.456767+00