How to correctly setup autorestart for a postgres application?

Questions / Help
,
1

Hello, I’m a new Fly.io user and still setting up my first project.

So far, I created an application my app and a database my-app-db. They are connected with each other, and while the postgres application is still running, my-app wakes up successfully within a couple of seconds, and all is well.

However, I cannot find a way to “unsuspend” my postgres application. It has the default configuration, that I retrieved and pasted down below:

# fly.toml app configuration file generated for my-app-db on 2024-07-28T00:28:20+02:00
#
# See https://fly.io/docs/reference/configuration/ for information about how to use this file.
#

app = 'my-app-db'
primary_region = 'lhr'

[env]
  FLY_SCALE_TO_ZERO = '1h'
  PRIMARY_REGION = 'lhr'

[[mounts]]
  source = 'pg_data'
  destination = '/data'

[[services]]
  protocol = 'tcp'
  internal_port = 5432
  auto_start_machines = true

  [[services.ports]]
    port = 5432
    handlers = ['pg_tls']

  [services.concurrency]
    type = 'connections'
    hard_limit = 1000
    soft_limit = 1000

[[services]]
  protocol = 'tcp'
  internal_port = 5433
  auto_start_machines = true

  [[services.ports]]
    port = 5433
    handlers = ['pg_tls']

  [services.concurrency]
    type = 'connections'
    hard_limit = 1000
    soft_limit = 1000

[checks]
  [checks.pg]
    port = 5500
    type = 'http'
    interval = '15s'
    timeout = '10s'
    path = '/flycheck/pg'

  [checks.role]
    port = 5500
    type = 'http'
    interval = '15s'
    timeout = '10s'
    path = '/flycheck/role'

  [checks.vm]
    port = 5500
    type = 'http'
    interval = '15s'
    timeout = '10s'
    path = '/flycheck/vm'

[[metrics]]
  port = 9187
  path = '/metrics'

It has the following settings:

[[services]]
  protocol = 'tcp'
  internal_port = 5433
  auto_start_machines = true

So, it should get unsuspended when receiving an incoming request, right? So I don’t know what’s missing and how to fix this.

Any help is welcome :sweat_smile:

Thank you!

2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.