Skip to content

Instantly share code, notes, and snippets.

@Rio517

Rio517/create_from_snapshot_debug_log.log Secret

Created September 4, 2023 16:19
Show Gist options
  • Save Rio517/d40e07a165baaa36a9fec558c09bf879 to your computer and use it in GitHub Desktop.
Save Rio517/d40e07a165baaa36a9fec558c09bf879 to your computer and use it in GitHub Desktop.
Download ZIP
Support files for Fly.io snapshot restore
Raw
create_from_snapshot_debug_log.log
➜ petal_ww git:(main) ✗ LOG_LEVEL=DEBUG fly postgres create --snapshot-id [REDACTED]
DEBUG Loaded flyctl config from/home/[REDACTED]/.fly/config.yml
DEBUG determined hostname: "my-computer"
DEBUG determined working directory: "/home/[REDACTED]/code/wunderwork/petal_ww"
DEBUG determined user home directory: "/home/[REDACTED]"
DEBUG determined config directory: "/home/[REDACTED]/.fly"
DEBUG ensured config directory exists.
DEBUG ensured config directory perms.
DEBUG cache loaded.
DEBUG config initialized.
DEBUG skipped querying for new release
DEBUG client initialized.
DEBUG Config has metrics token
DEBUG Starting task manager
DEBUG --> POST https://api.fly.io/graphql
? Choose an app name (leave blank to generate one): DEBUG {
"query": "query { platform { requestRegion regions { name code latitude longitude gatewayAvailable requiresPaidPlan } } }",
"variables": null
}
DEBUG {}
DEBUG <-- 200 https://api.fly.io/graphql (207.73ms)
DEBUG {
"data": {
"platform": {
"requestRegion": "fra",
"regions": [
{
"name": "Amsterdam, Netherlands",
"code": "ams",
"latitude": 52.374342,
"longitude": 4.895439,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Stockholm, Sweden",
"code": "arn",
"latitude": 59.6512,
"longitude": 17.9178,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Atlanta, Georgia (US)",
"code": "atl",
"latitude": 33.6407,
"longitude": -84.4277,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Bogotá, Colombia",
"code": "bog",
"latitude": 4.70159,
"longitude": -74.1469,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Mumbai, India",
"code": "bom",
"latitude": 19.097403,
"longitude": 72.874245,
"gatewayAvailable": false,
"requiresPaidPlan": true
},
{
"name": "Boston, Massachusetts (US)",
"code": "bos",
"latitude": 42.366978,
"longitude": -71.022362,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Paris, France",
"code": "cdg",
"latitude": 48.860875,
"longitude": 2.353477,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Denver, Colorado (US)",
"code": "den",
"latitude": 39.7392,
"longitude": -104.9847,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Dallas, Texas (US)",
"code": "dfw",
"latitude": 32.778287,
"longitude": -96.7984,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Secaucus, NJ (US)",
"code": "ewr",
"latitude": 40.789543,
"longitude": -74.056534,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Ezeiza, Argentina",
"code": "eze",
"latitude": -34.8222,
"longitude": -58.5358,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Frankfurt, Germany",
"code": "fra",
"latitude": 50.1167,
"longitude": 8.6833,
"gatewayAvailable": true,
"requiresPaidPlan": true
},
{
"name": "Guadalajara, Mexico",
"code": "gdl",
"latitude": 20.5217,
"longitude": -103.3109,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Rio de Janeiro, Brazil",
"code": "gig",
"latitude": -22.8099,
"longitude": -43.2505,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Sao Paulo, Brazil",
"code": "gru",
"latitude": -23.549664,
"longitude": -46.654351,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Hong Kong, Hong Kong",
"code": "hkg",
"latitude": 22.250971,
"longitude": 114.203224,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Ashburn, Virginia (US)",
"code": "iad",
"latitude": 39.02214,
"longitude": -77.462556,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Johannesburg, South Africa",
"code": "jnb",
"latitude": -26.13629,
"longitude": 28.20298,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Los Angeles, California (US)",
"code": "lax",
"latitude": 33.9416,
"longitude": -118.4085,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "London, United Kingdom",
"code": "lhr",
"latitude": 51.516434,
"longitude": -0.125656,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Chennai (Madras), India",
"code": "maa",
"latitude": 13.064429,
"longitude": 80.253067,
"gatewayAvailable": true,
"requiresPaidPlan": true
},
{
"name": "Madrid, Spain",
"code": "mad",
"latitude": 40.4381,
"longitude": -3.82,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Miami, Florida (US)",
"code": "mia",
"latitude": 25.7877,
"longitude": -80.2241,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Tokyo, Japan",
"code": "nrt",
"latitude": 35.621608,
"longitude": 139.741851,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Chicago, Illinois (US)",
"code": "ord",
"latitude": 41.891544,
"longitude": -87.630386,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Bucharest, Romania",
"code": "otp",
"latitude": 44.4325,
"longitude": 26.1039,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Phoenix, Arizona (US)",
"code": "phx",
"latitude": 33.416084,
"longitude": -112.009482,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Querétaro, Mexico",
"code": "qro",
"latitude": 20.62,
"longitude": -100.1863,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Santiago, Chile",
"code": "scl",
"latitude": -33.36572,
"longitude": -70.64292,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Seattle, Washington (US)",
"code": "sea",
"latitude": 47.6097,
"longitude": -122.3331,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Singapore, Singapore",
"code": "sin",
"latitude": 1.3,
"longitude": 103.8,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "San Jose, California (US)",
"code": "sjc",
"latitude": 37.351601,
"longitude": -121.896744,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Sydney, Australia",
"code": "syd",
"latitude": -33.866033,
"longitude": 151.20693,
"gatewayAvailable": true,
"requiresPaidPlan": false
},
{
"name": "Warsaw, Poland",
"code": "waw",
"latitude": 52.1657,
"longitude": 20.9671,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Montreal, Canada",
"code": "yul",
"latitude": 45.48647,
"longitude": -73.75549,
"gatewayAvailable": false,
"requiresPaidPlan": false
},
{
"name": "Toronto, Canada",
"code": "yyz",
"latitude": 43.644632,
"longitude": -79.384228,
"gatewayAvailable": true,
"requiresPaidPlan": false
}
]
}
}
}
? Choose an app name (leave blank to generate one):
DEBUG --> POST https://api.fly.io/graphql
DEBUG {
"query": "query($admin: Boolean!) { organizations(admin: $admin) { nodes { id slug name type paidPlan } } }",
"variables": {
"admin": false
}
}
DEBUG {}
DEBUG <-- 200 https://api.fly.io/graphql (138.86ms)
DEBUG {
"data": {
"organizations": {
"nodes": [
{
"id": "[REDACTED]",
"slug": "personal",
"name": "[REDACTED_ORG_NAME]",
"type": "PERSONAL",
"paidPlan": true
}
]
}
}
}
automatically selected personal organization: [REDACTED_ORG_NAME]
? Select region: Frankfurt, Germany (fra)
? Select configuration: Specify custom configuration
? Initial cluster size - Specify at least 3 for HA 1
? Select VM size: shared-cpu-2x - CPU Kind: Shared, vCPUs: 2, Memory: 4GB
? Volume size 10
Creating postgres cluster in organization personal
Creating app...
DEBUG --> POST https://api.fly.io/graphql
DEBUG {
"query": "mutation($input: CreateAppInput!) { createApp(input: $input) { app { id name organization { slug } config { definition } regions { name code } } } }",
"variables": {
"input": {
"organizationId": "[REDACTED]",
"name": "",
"preferredRegion": "fra",
"appRoleId": "postgres_cluster",
"machines": false
}
}
}
DEBUG {}
DEBUG <-- 200 https://api.fly.io/graphql (480.56ms)
DEBUG {
"data": {
"createApp": {
"app": {
"id": "falling-surf-3933",
"name": "falling-surf-3933",
"organization": {
"slug": "personal"
},
"config": {
"definition": {
"kill_timeout": 5,
"kill_signal": "SIGINT",
"processes": [],
"experimental": {
"auto_rollback": true
},
"services": [
{
"processes": [
"app"
],
"protocol": "tcp",
"internal_port": 8080,
"concurrency": {
"soft_limit": 20,
"hard_limit": 25,
"type": "connections"
},
"ports": [
{
"port": 80,
"handlers": [
"http"
],
"force_https": true
},
{
"port": 443,
"handlers": [
"tls",
"http"
]
}
],
"tcp_checks": [
{
"interval": "15s",
"timeout": "2s",
"grace_period": "1s",
"restart_limit": 0
}
],
"http_checks": [],
"script_checks": []
}
],
"env": {}
}
},
"regions": [
{
"name": "Frankfurt, Germany",
"code": "fra"
}
]
}
}
}
}
DEBUG --> POST https://api.fly.io/graphql
DEBUG {
"query": "mutation($input: AllocateIPAddressInput!) { allocateIpAddress(input: $input) { ipAddress { id address type region createdAt } } }",
"variables": {
"input": {
"appId": "falling-surf-3933",
"type": "private_v6",
"region": "fra",
"organizationId": "[REDACTED]"
}
}
}
DEBUG {}
DEBUG <-- 200 https://api.fly.io/graphql (180.61ms)
DEBUG {
"data": {
"allocateIpAddress": {
"ipAddress": {
"id": "ip_yqr890z4zwd2d6jn",
"address": "fdaa:1:da0b:0:1::10",
"type": "private_v6",
"region": "global",
"createdAt": "2023-09-04T13:52:49Z"
}
}
}
}
Setting secrets on app falling-surf-3933...
DEBUG --> POST https://api.fly.io/graphql
DEBUG {
"query": "mutation($input: IssueCertificateInput!) { issueCertificate(input: $input) { certificate, key } }",
"variables": {
"input": {
"appNames": [
"falling-surf-3933"
],
"organizationId": "[REDACTED]",
"principals": [
"root",
"fly",
"postgres"
],
"publicKey": "ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAICdktiJcTNI8HYKM9lmYTgYKLAQTA6SwRc32y0Xv3XkV"
}
}
}
DEBUG {}
DEBUG <-- 200 https://api.fly.io/graphql (280.41ms)
DEBUG {
"data": {
"issueCertificate": {
"certificate": "ssh-ed25519-cert-v01@openssh.com [REDACTED]",
"key": null
}
}
}
DEBUG --> POST https://api.fly.io/graphql
DEBUG {
"query": "mutation($appName: ID!) { enablePostgresConsul(input: {appId: $appName}) { consulUrl } }",
"variables": {
"appName": "falling-surf-3933"
}
}
DEBUG {}
DEBUG <-- 200 https://api.fly.io/graphql (840.42ms)
DEBUG {
"data": {
"enablePostgresConsul": {
"consulUrl": "https://:0df702d3-dcf5-f325-5f1a-1cabcefe910f@consul-fra-9.fly-shared.net/falling-surf-3933-w3pgqek0rrmqdv57/"
}
}
}
DEBUG --> POST https://api.fly.io/graphql
DEBUG {
"query": "mutation($input: SetSecretsInput!) { setSecrets(input: $input) { release { id version reason description user { id email name } evaluationId createdAt } } }",
"variables": {
"input": {
"appId": "falling-surf-3933",
"secrets": [
{
"key": "OPERATOR_PASSWORD",
"value": "[PASSWORD"
},
{
"key": "SSH_KEY",
"value": "-----BEGIN OPENSSH PRIVATE KEY-----[REDACTED]\n-----END OPENSSH PRIVATE KEY-----\n"
},
{
"key": "SSH_CERT",
"value": "ssh-ed25519-cert-v01[REDACTED]"
},
{
"key": "FLY_RESTORED_FROM",
"value": "[REDACTED]"
},
{
"key": "FLY_CONSUL_URL",
"value": "https://:0df702d3-dcf5-f325-5f1a-1cabcefe910f@consul-fra-9.fly-shared.net/falling-surf-3933-w3pgqek0rrmqdv57/"
},
{
"key": "SU_PASSWORD",
"value": "[REDACTED]"
},
{
"key": "REPL_PASSWORD",
"value": "[REDACTED]"
}
]
}
}
}
DEBUG {}
DEBUG <-- 200 https://api.fly.io/graphql (809.72ms)
DEBUG {
"data": {
"setSecrets": {
"release": null
}
}
}
DEBUG --> POST https://api.fly.io/graphql
DEBUG {
"query": "query($repository: String!, $snapshotId: ID) { latestImageTag(repository: $repository, snapshotId: $snapshotId) }",
"variables": {
"repository": "flyio/postgres-flex",
"snapshotId": "[REDACTED]"
}
}
DEBUG {}
DEBUG <-- 200 https://api.fly.io/graphql (261.2ms)
DEBUG {
"data": {
"latestImageTag": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62"
}
}
Restoring 1 of 1 machines with image flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62
DEBUG --> POST https://api.machines.dev/v1/apps/falling-surf-3933/volumes
DEBUG {
"name": "pg_data",
"region": "fra",
"size_gb": 10,
"encrypted": true,
"require_unique_zone": false,
"machines_only": null,
"snapshot_id": "[REDACTED]",
"source_volume_id": null,
"compute": null,
"host_dedication_id": ""
}
DEBUG {0xc000ffc6c0}
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/volumes (3.3s)
DEBUG {
"id": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data",
"state": "restoring",
"size_gb": 10,
"region": "fra",
"zone": "7cbc",
"encrypted": true,
"attached_machine_id": null,
"attached_alloc_id": null,
"created_at": "2023-09-04T13:52:52.428Z",
"blocks": 0,
"block_size": 0,
"blocks_free": 0,
"blocks_avail": 0,
"fstype": "",
"host_dedication_key": ""
}
DEBUG --> POST https://api.machines.dev/v1/apps/falling-surf-3933/machines
DEBUG {
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"path": "/data",
"volume": "vol_nv8jjk7wl2mxnq5r"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
},
"host_dedication_id": ""
},
"region": "fra"
}
DEBUG {0xc001066d80}
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines (1.06s)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "created",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:52:55Z",
"events": [
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "warning",
"output": "the machine hasn't started",
"updated_at": "2023-09-04T13:52:55.524Z"
},
{
"name": "role",
"status": "warning",
"output": "the machine hasn't started",
"updated_at": "2023-09-04T13:52:55.524Z"
},
{
"name": "vm",
"status": "warning",
"output": "the machine hasn't started",
"updated_at": "2023-09-04T13:52:55.524Z"
}
]
}
Waiting for machine to start...
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]/wait?instance_id=[REDACTED]&state=started&timeout=60
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]/wait?instance_id=[REDACTED]&state=started&timeout=60 (23.59s)
DEBUG {
"ok": true
}
Machine [REDACTED] is created
==> Monitoring health checks
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (33.02ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "vm",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 0/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (38.81ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "vm",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 0/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (44.49ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "vm",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 0/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (33.66ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "vm",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 0/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (31.81ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "vm",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 0/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (38.88ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "vm",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 0/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (34.25ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "passing",
"output": "[✓] connections: 7 used, 3 reserved, 300 max (5.57ms)\n[✓] cluster-locks: No active locks detected (42.64µs)\n[✓] disk-capacity: 5.3% - readonly mode will be enabled at 90.0% (15.18µs)",
"updated_at": "2023-09-04T13:53:24.842Z"
},
{
"name": "vm",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 1/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (33.64ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "passing",
"output": "[✓] connections: 7 used, 3 reserved, 300 max (5.57ms)\n[✓] cluster-locks: No active locks detected (42.64µs)\n[✓] disk-capacity: 5.3% - readonly mode will be enabled at 90.0% (15.18µs)",
"updated_at": "2023-09-04T13:53:24.842Z"
},
{
"name": "vm",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 1/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (34.26ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "passing",
"output": "[✓] connections: 7 used, 3 reserved, 300 max (5.57ms)\n[✓] cluster-locks: No active locks detected (42.64µs)\n[✓] disk-capacity: 5.3% - readonly mode will be enabled at 90.0% (15.18µs)",
"updated_at": "2023-09-04T13:53:24.842Z"
},
{
"name": "vm",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 1/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (33.33ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[[REDACTED]]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "passing",
"output": "[✓] connections: 7 used, 3 reserved, 300 max (5.57ms)\n[✓] cluster-locks: No active locks detected (42.64µs)\n[✓] disk-capacity: 5.3% - readonly mode will be enabled at 90.0% (15.18µs)",
"updated_at": "2023-09-04T13:53:24.842Z"
},
{
"name": "vm",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 1/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (36.76ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "passing",
"output": "[✓] connections: 7 used, 3 reserved, 300 max (5.57ms)\n[✓] cluster-locks: No active locks detected (42.64µs)\n[✓] disk-capacity: 5.3% - readonly mode will be enabled at 90.0% (15.18µs)",
"updated_at": "2023-09-04T13:53:24.842Z"
},
{
"name": "vm",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 1/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (35.07ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "passing",
"output": "[✓] connections: 7 used, 3 reserved, 300 max (5.57ms)\n[✓] cluster-locks: No active locks detected (42.64µs)\n[✓] disk-capacity: 5.3% - readonly mode will be enabled at 90.0% (15.18µs)",
"updated_at": "2023-09-04T13:53:24.842Z"
},
{
"name": "vm",
"status": "passing",
"output": "[✓] checkDisk: 9.28 GB (94.7%) free space on /data/ (52.29µs)\n[✓] checkLoad: load averages: 0.00 0.00 0.00 (63.39µs)\n[✓] memory: system spent 0s of the last 60s waiting on memory (35.96µs)\n[✓] cpu: system spent 204ms of the last 60s waiting on cpu (31.85µs)\n[✓] io: system spent 192ms of the last 60s waiting on io (32.55µs)",
"updated_at": "2023-09-04T13:53:30.841Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 2/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (34.75ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "passing",
"output": "[✓] connections: 7 used, 3 reserved, 300 max (5.57ms)\n[✓] cluster-locks: No active locks detected (42.64µs)\n[✓] disk-capacity: 5.3% - readonly mode will be enabled at 90.0% (15.18µs)",
"updated_at": "2023-09-04T13:53:24.842Z"
},
{
"name": "vm",
"status": "passing",
"output": "[✓] checkDisk: 9.28 GB (94.7%) free space on /data/ (52.29µs)\n[✓] checkLoad: load averages: 0.00 0.00 0.00 (63.39µs)\n[✓] memory: system spent 0s of the last 60s waiting on memory (35.96µs)\n[✓] cpu: system spent 204ms of the last 60s waiting on cpu (31.85µs)\n[✓] io: system spent 192ms of the last 60s waiting on io (32.55µs)",
"updated_at": "2023-09-04T13:53:30.841Z"
},
{
"name": "role",
"status": "warning",
"updated_at": "2023-09-04T13:53:18.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 2/3)
DEBUG --> GET https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED]
DEBUG <-- 200 https://api.machines.dev/v1/apps/falling-surf-3933/machines/[REDACTED] (45.83ms)
DEBUG {
"id": "[REDACTED]",
"name": "dawn-field-3990",
"state": "started",
"region": "fra",
"instance_id": "[REDACTED]",
"private_ip": "fdaa:1:da0b:a7b:15b:7f3e:bdce:2",
"config": {
"env": {
"PRIMARY_REGION": "fra"
},
"init": {},
"metadata": {
"fly-managed-postgres": "true",
"fly_flyctl_version": "0.1.87",
"fly_platform_version": "v2",
"managed-by-fly-deploy": "true"
},
"mounts": [
{
"encrypted": true,
"path": "/data",
"size_gb": 10,
"volume": "vol_nv8jjk7wl2mxnq5r",
"name": "pg_data"
}
],
"services": [
{
"protocol": "tcp",
"internal_port": 5432,
"autostart": false,
"ports": [
{
"port": 5432,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
},
{
"protocol": "tcp",
"internal_port": 5433,
"autostart": false,
"ports": [
{
"port": 5433,
"handlers": [
"pg_tls"
]
}
],
"concurrency": {
"type": "connections",
"hard_limit": 1000,
"soft_limit": 1000
},
"force_instance_key": null
}
],
"metrics": {
"port": 9187,
"path": "/metrics"
},
"checks": {
"pg": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/pg"
},
"role": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/role"
},
"vm": {
"port": 5500,
"type": "http",
"interval": "15s",
"timeout": "10s",
"path": "/flycheck/vm"
}
},
"image": "flyio/postgres-flex:15.3@sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"restart": {
"policy": "always"
},
"guest": {
"cpu_kind": "shared",
"cpus": 2,
"memory_mb": 4096
}
},
"image_ref": {
"registry": "registry-1.docker.io",
"repository": "flyio/postgres-flex",
"tag": "15.3",
"digest": "sha256:e5882c1841195860fb002e4eebfb84b47afbf193e0c7bd739dfd1056ef7c6b62",
"labels": {
"fly.app_role": "postgres_cluster",
"fly.pg-manager": "repmgr",
"fly.pg-version": "15.3-1.pgdg120+1",
"fly.version": "v0.0.43"
}
},
"created_at": "2023-09-04T13:52:55Z",
"updated_at": "2023-09-04T13:53:18Z",
"events": [
{
"id": "01H9G7G6WX7Y6CQKPQNMCQEGQZ",
"type": "start",
"status": "started",
"source": "flyd",
"timestamp": 1693835598749
},
{
"id": "01H9G7FG74TB65YPQQKY0MGQEP",
"type": "launch",
"status": "created",
"source": "user",
"timestamp": 1693835575524
}
],
"checks": [
{
"name": "pg",
"status": "passing",
"output": "[✓] connections: 7 used, 3 reserved, 300 max (5.57ms)\n[✓] cluster-locks: No active locks detected (42.64µs)\n[✓] disk-capacity: 5.3% - readonly mode will be enabled at 90.0% (15.18µs)",
"updated_at": "2023-09-04T13:53:24.842Z"
},
{
"name": "vm",
"status": "passing",
"output": "[✓] checkDisk: 9.28 GB (94.7%) free space on /data/ (52.29µs)\n[✓] checkLoad: load averages: 0.00 0.00 0.00 (63.39µs)\n[✓] memory: system spent 0s of the last 60s waiting on memory (35.96µs)\n[✓] cpu: system spent 204ms of the last 60s waiting on cpu (31.85µs)\n[✓] io: system spent 192ms of the last 60s waiting on io (32.55µs)",
"updated_at": "2023-09-04T13:53:30.841Z"
},
{
"name": "role",
"status": "passing",
"output": "primary",
"updated_at": "2023-09-04T13:53:32.842Z"
}
]
}
Waiting for [REDACTED] to become healthy (started, 3/3)
Postgres cluster falling-surf-3933 created
Username: postgres
Password: [PASSWORD]
Hostname: falling-surf-3933.internal
Flycast: fdaa:1:da0b:0:1::10
Proxy port: 5432
Postgres port: 5433
Connection string: postgres://postgres:[PASSWORD]@falling-surf-3933.flycast:5432
Save your credentials in a secure place -- you won't be able to see them again!
Connect to postgres
Any app within the [REDACTED_ORG_NAME] organization can connect to this Postgres using the above connection string
Now that you've set up Postgres, here's what you need to understand: https://fly.io/docs/postgres/getting-started/what-you-should-know/
DEBUG Task manager done
➜ petal_ww git:(main) ✗
Raw
restore_machine_failing_logs.log
flyctl logs -a falling-surf-3933s
2023-09-04T13:52:55Z runner[xxx] fra [info]Pulling container image registry-1.docker.io/flyio/postgres-flex:15.3
2023-09-04T13:53:05Z runner[xxx] fra [info]Successfully prepared image registry-1.docker.io/flyio/postgres-flex:15.3 (10.090954717s)
2023-09-04T13:53:15Z runner[xxx] fra [info]Setting up volume 'pg_data'
2023-09-04T13:53:15Z runner[xxx] fra [info]Opening encrypted volume
2023-09-04T13:53:17Z runner[xxx] fra [info]Configuring firecracker
2023-09-04T13:53:18Z app[xxx] fra [info][ 0.136002] PCI: Fatal: No config space access function found
2023-09-04T13:53:18Z app[xxx] fra [info] INFO Starting init (commit: 5293a085)...
2023-09-04T13:53:18Z app[xxx] fra [info] INFO Mounting /dev/vdb at /data w/ uid: 0, gid: 0 and chmod 0755
2023-09-04T13:53:18Z app[xxx] fra [info] INFO Resized /data to 10733223936 bytes
2023-09-04T13:53:18Z app[xxx] fra [info] INFO Preparing to run: `docker-entrypoint.sh start` as root
2023-09-04T13:53:18Z app[xxx] fra [info] INFO [fly api proxy] listening at /.fly/api
2023-09-04T13:53:18Z app[xxx] fra [info]2023/09/04 13:53:18 listening on [fdaa:1:da0b:a7b:15b:7f3e:bdce:2]:22 (DNS: [fdaa::3]:53)
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | Running...
2023-09-04T13:53:18Z health[xxx] fra [warn]Health check for your postgres role is warning. Your cluster's membership might be affected.
2023-09-04T13:53:18Z health[xxx] fra [warn]Health check for your postgres database is warning. Your database might be malfunctioning.
2023-09-04T13:53:18Z health[xxx] fra [warn]Health check for your postgres vm is warning. Your instance might be hitting resource limits.
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | 2023-09-04 13:53:18.857 UTC [285] LOG: starting PostgreSQL 15.3 (Debian 15.3-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | 2023-09-04 13:53:18.857 UTC [285] LOG: listening on IPv6 address "fdaa:1:da0b:a7b:15b:7f3e:bdce:2", port 5433
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | 2023-09-04 13:53:18.858 UTC [285] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5433"
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | 2023-09-04 13:53:18.862 UTC [293] LOG: database system was interrupted; last known up at 2023-09-03 13:50:32 UTC
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | 2023-09-04 13:53:18.922 UTC [293] LOG: database system was not properly shut down; automatic recovery in progress
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | 2023-09-04 13:53:18.926 UTC [293] LOG: redo starts at 0/34CA8A0
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | 2023-09-04 13:53:18.927 UTC [293] LOG: invalid record length at 0/34CBEF8: wanted 24, got 0
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | 2023-09-04 13:53:18.927 UTC [293] LOG: redo done at 0/34CBED0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | 2023-09-04 13:53:18.930 UTC [291] LOG: checkpoint starting: end-of-recovery immediate wait
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | 2023-09-04 13:53:18.935 UTC [291] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.005 s; sync files=4, longest=0.001 s, average=0.001 s; distance=5 kB, estimate=5 kB
2023-09-04T13:53:18Z app[xxx] fra [info]postgres | 2023-09-04 13:53:18.942 UTC [285] LOG: database system is ready to accept connections
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.737 UTC [291] LOG: checkpoint starting: immediate force wait
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.740 UTC [291] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=4, longest=0.001 s, average=0.001 s; distance=9 kB, estimate=9 kB
2023-09-04T13:53:19Z app[xxx] fra [info]Supervisor stopping
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | Stopping interrupt...
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.784 UTC [285] LOG: received fast shutdown request
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.785 UTC [285] LOG: aborting any active transactions
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.788 UTC [285] LOG: background worker "logical replication launcher" (PID 296) exited with exit code 1
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.791 UTC [291] LOG: shutting down
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.791 UTC [291] LOG: checkpoint starting: shutdown immediate
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.796 UTC [291] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.005 s; sync files=3, longest=0.001 s, average=0.001 s; distance=2 kB, estimate=8 kB
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.804 UTC [285] LOG: database system is shut down
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | Process exited 0
2023-09-04T13:53:19Z app[xxx] fra [info]proxy | Running...
2023-09-04T13:53:19Z app[xxx] fra [info]repmgrd | Running...
2023-09-04T13:53:19Z app[xxx] fra [info]monitor | Running...
2023-09-04T13:53:19Z app[xxx] fra [info]admin | Running...
2023-09-04T13:53:19Z app[xxx] fra [info]exporter | Running...
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | Running...
2023-09-04T13:53:19Z app[xxx] fra [info]monitor | Monitoring dead members
2023-09-04T13:53:19Z app[xxx] fra [info]monitor | Monitoring cluster state
2023-09-04T13:53:19Z app[xxx] fra [info]monitor | Monitoring replication slots
2023-09-04T13:53:19Z app[xxx] fra [info]monitor | Pruning every 24h0m0s...
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.930 UTC [325] LOG: starting PostgreSQL 15.3 (Debian 15.3-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.930 UTC [325] LOG: listening on IPv4 address "0.0.0.0", port 5433
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.930 UTC [325] LOG: listening on IPv6 address "::", port 5433
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.934 UTC [325] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5433"
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.943 UTC [344] LOG: database system was shut down at 2023-09-04 13:53:19 UTC
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.947 UTC [325] LOG: database system is ready to accept connections
2023-09-04T13:53:19Z app[xxx] fra [info]proxy | [NOTICE] (306) : New worker (348) forked
2023-09-04T13:53:19Z app[xxx] fra [info]proxy | [NOTICE] (306) : Loading success.
2023-09-04T13:53:19Z app[xxx] fra [info]repmgrd | [2023-09-04 13:53:19] [NOTICE] repmgrd (repmgrd 5.3.3) starting up
2023-09-04T13:53:19Z app[xxx] fra [info]repmgrd | [2023-09-04 13:53:19] [INFO] connecting to database "host=fdaa:1:da0b:a7b:15b:7f3e:bdce:2 port=5433 user=repmgr dbname=repmgr connect_timeout=5"
2023-09-04T13:53:19Z app[xxx] fra [info]postgres | 2023-09-04 13:53:19.982 UTC [350] FATAL: database "repmgr" does not exist
2023-09-04T13:53:19Z app[xxx] fra [info]proxy | [WARNING] (348) : bk_db/pg1 changed its IP from (none) to fdaa:1:da0b:a7b:15b:7f3e:bdce:2 by flydns/dns1.
2023-09-04T13:53:19Z app[xxx] fra [info]proxy | [WARNING] (348) : Server bk_db/pg1 ('fra.falling-surf-3933.internal') is UP/READY (resolves again).
2023-09-04T13:53:19Z app[xxx] fra [info]proxy | [WARNING] (348) : Server bk_db/pg1 administratively READY thanks to valid DNS answer.
2023-09-04T13:53:19Z app[xxx] fra [info]repmgrd | [2023-09-04 13:53:19] [ERROR] connection to database failed
2023-09-04T13:53:19Z app[xxx] fra [info]repmgrd | [2023-09-04 13:53:19] [DETAIL]
2023-09-04T13:53:19Z app[xxx] fra [info]repmgrd | connection to server at "fdaa:1:da0b:a7b:15b:7f3e:bdce:2", port 5433 failed: FATAL: database "repmgr" does not exist
2023-09-04T13:53:19Z app[xxx] fra [info]repmgrd |
2023-09-04T13:53:19Z app[xxx] fra [info]repmgrd | [2023-09-04 13:53:19] [DETAIL] attempted to connect using:
2023-09-04T13:53:19Z app[xxx] fra [info]repmgrd | user=repmgr connect_timeout=5 dbname=repmgr host=fdaa:1:da0b:a7b:15b:7f3e:bdce:2 port=5433 fallback_application_name=repmgr options=-csearch_path=
2023-09-04T13:53:19Z app[xxx] fra [info]repmgrd | exit status 6
2023-09-04T13:53:19Z app[xxx] fra [info]repmgrd | restarting in 5s [attempt 1]
2023-09-04T13:53:20Z app[xxx] fra [info]Registering primary
2023-09-04T13:53:24Z health[xxx] fra [info]Health check for your postgres database is now passing.
2023-09-04T13:53:24Z app[xxx] fra [info]repmgrd | Running...
2023-09-04T13:53:25Z app[xxx] fra [info]repmgrd | [2023-09-04 13:53:25] [NOTICE] repmgrd (repmgrd 5.3.3) starting up
2023-09-04T13:53:25Z app[xxx] fra [info]repmgrd | [2023-09-04 13:53:25] [INFO] connecting to database "host=fdaa:1:da0b:a7b:15b:7f3e:bdce:2 port=5433 user=repmgr dbname=repmgr connect_timeout=5"
2023-09-04T13:53:25Z app[xxx] fra [info]repmgrd | INFO: set_repmgrd_pid(): provided pidfile is /tmp/repmgrd.pid
2023-09-04T13:53:25Z app[xxx] fra [info]repmgrd | [2023-09-04 13:53:25] [NOTICE] starting monitoring of node "fdaa:1:da0b:a7b:15b:7f3e:bdce:2" (ID: 416031879)
2023-09-04T13:53:25Z app[xxx] fra [info]repmgrd | [2023-09-04 13:53:25] [INFO] "connection_check_type" set to "ping"
2023-09-04T13:53:25Z app[xxx] fra [info]repmgrd | [2023-09-04 13:53:25] [NOTICE] monitoring cluster primary "fdaa:1:da0b:a7b:15b:7f3e:bdce:2" (ID: 416031879)
2023-09-04T13:53:30Z health[xxx] fra [info]Health check for your postgres vm is now passing.
2023-09-04T13:53:32Z health[xxx] fra [info]Health check for your postgres role is now passing.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment