Postgres app failed - restart didn't helped

1

Hi,

as in title, suddenly my postgres app stopped to work :confused: the servers start to refuse any connection, after the restart I can see that deployment is in pending state and flyctl status -a my-postgres command gives me that:

Deployment Status
  ID          = 097ac02c-e0a2-1e5d-da28-142685f151f7
  Version     = v3
  Status      = running
  Description = Deployment is running
  Instances   = 1 desired, 1 placed, 0 healthy, 0 unhealthy

Instances
ID              PROCESS VERSION REGION  DESIRED STATUS  HEALTH CHECKS   RESTARTS        CREATED
be721702        app     3       fra     run     pending                 0               2m38s ago

It’s second restart, the first hanged up for 16 minutes or so.

So what are my options?

2

ok, it seems to be working now

3

Hey @roszman,

Couple things to point out.

  1. I would recommend migrating to Machines and our new Flex implementation for increased reliability. We just pushed out a new import feature to make this process easier: New Postgres Import Feature

  2. You’re not running an HA setup, so you’re always going to be susceptible to downtime in the event of network or hardware failure.

Let me know if you have any questions on anything.

2 Likes