# \#postgres **URL:** https://community.fly.io/tag/postgres/18.md [Latest](https://community.fly.io/latest.md) · [Categories](https://community.fly.io/categories.md) · [Tags](https://community.fly.io/tags.md) --- ## [pg\_tls rejects libpq 17+ clients ("no application protocol"), and the postgresql ALPN can't be configured](https://community.fly.io/t/pg-tls-rejects-libpq-17-clients-no-application-protocol-and-the-postgresql-alpn-cant-be-configured/28898)
**Author:** [@nathanjcochran](https://community.fly.io/u/nathanjcochran)\ **Replies:** 1\ **Last updated:** [October 22, 2026, 7:31pm UTC](https://community.fly.io/t/pg-tls-rejects-libpq-17-clients-no-application-protocol-and-the-postgresql-alpn-cant-be-configured/28898 "2026-10-22T19:31:45Z")
We run a public Postgres-protocol service on Fly using the pg\_tls handler, with a Fly-managed Let’s Encrypt cert for our custom domain. Clients using libpq 17 or newer (psql 17+, psycopg, pgAdmin 8.13+, etc.) can’t conne… --- ## [GRU: volume on the failed 4-node chassis, please preserve data / snapshot when power is restored](https://community.fly.io/t/gru-volume-on-the-failed-4-node-chassis-please-preserve-data-snapshot-when-power-is-restored/28852)
**Author:** [@pzzb](https://community.fly.io/u/pzzb)\ **Replies:** 17\ **Last updated:** [October 21, 2026, 12:24am UTC](https://community.fly.io/t/gru-volume-on-the-failed-4-node-chassis-please-preserve-data-snapshot-when-power-is-restored/28852 "2026-10-21T00:24:19Z")
Hi Fly team, Following up from the (now closed) rolling-reboots thread. Per Lillian’s note, our host appears to be on the 4-node chassis in GRU whose power supplies failed. We received the hardware-failure email for it. … --- ## [Unmanaged Postgres recovery from snapshot - Consul error](https://community.fly.io/t/unmanaged-postgres-recovery-from-snapshot-consul-error/28869)
**Author:** [@limaantonio](https://community.fly.io/u/limaantonio)\ **Replies:** 2\ **Last updated:** [October 20, 2026, 5:42am UTC](https://community.fly.io/t/unmanaged-postgres-recovery-from-snapshot-consul-error/28869 "2026-10-20T05:42:37Z")
Hi Fly Team, My app upg-tranquil-coral-757 was hosted in GRU and suffered from the recent hardware failure. I managed to create a new volume in IAD from a recent snapshot (vol\_4912z9037n0k00or). However, when I try to r… --- ## [local backup from mpg cluster fails](https://community.fly.io/t/local-backup-from-mpg-cluster-fails/28777)
**Author:** [@bwhitford](https://community.fly.io/u/bwhitford)\ **Replies:** 2\ **Last updated:** [October 12, 2026, 8:41pm UTC](https://community.fly.io/t/local-backup-from-mpg-cluster-fails/28777 "2026-10-12T20:41:39Z")
I have read the docs and tried the ‘fly proxy / pg\_dump’ process several times with no success. % fly proxy 5433:5432 -a appname % pg\_dump -h localhost -p5433 -U postgres -F c dbname\_db \> dump.sql My pg\_dump command c… --- ## [Postgres Flex cluster has no writable primary, all nodes are in recovery](https://community.fly.io/t/postgres-flex-cluster-has-no-writable-primary-all-nodes-are-in-recovery/28767)
**Author:** [@etm](https://community.fly.io/u/etm)\ **Replies:** 1\ **Last updated:** [October 7, 2026, 4:31pm UTC](https://community.fly.io/t/postgres-flex-cluster-has-no-writable-primary-all-nodes-are-in-recovery/28767 "2026-10-07T16:31:29Z")
Hi, our Postgres Flex cluster suddenly became read-only even though it had been working normally before. Fly reports one machine as primary and the other two as replica, but PostgreSQL on all three machines returns: pg… --- ## [High private-network latency (~55 ms RTT) between two machines in gru](https://community.fly.io/t/high-private-network-latency-55-ms-rtt-between-two-machines-in-gru/28744)
**Author:** [@ale\_delisio](https://community.fly.io/u/ale_delisio)\ **Replies:** 3\ **Last updated:** [October 5, 2026, 9:02pm UTC](https://community.fly.io/t/high-private-network-latency-55-ms-rtt-between-two-machines-in-gru/28744 "2026-10-05T21:02:10Z")
Hi! Since around 2026-10-02 23:27 UTC we see unusually high latency on the private network (6PN) between two of our apps, both in gru: parking-garage-cloud, machine d8d1376a004418 (shared-cpu-1x, 1 GB). It was recreate… --- ## [Expectations when migrating from self-managed to managed Postgres](https://community.fly.io/t/expectations-when-migrating-from-self-managed-to-managed-postgres/28742)
**Author:** [@LensLlama](https://community.fly.io/u/LensLlama)\ **Replies:** 3\ **Last updated:** [October 2, 2026, 6:12pm UTC](https://community.fly.io/t/expectations-when-migrating-from-self-managed-to-managed-postgres/28742 "2026-10-02T18:12:20Z")
Hi, we’re planning to migrate a production app from self-managed Fly Postgres (postgres-flex) to Managed Postgres, Basic plan, PG 17, region sjc. Before we do, could you confirm: How often MPG takes automatic backups, … --- ## [Recurring Postgres flex connection timeouts from one Machine while another works](https://community.fly.io/t/recurring-postgres-flex-connection-timeouts-from-one-machine-while-another-works/28700)
**Author:** [@travisp](https://community.fly.io/u/travisp)\ **Replies:** 4\ **Last updated:** [September 28, 2026, 4:23pm UTC](https://community.fly.io/t/recurring-postgres-flex-connection-timeouts-from-one-machine-while-another-works/28700 "2026-09-28T16:23:03Z")
I’m running Windmill with two worker Machines and a single-node Postgres Flex database in iad. One of my workers repeatedly loses database connectivity even though the other keeps working. It happens to me almost daily.… --- ## [Can't reach two Postgres machines in yyz over 6PN since ~13:55 UTC](https://community.fly.io/t/cant-reach-two-postgres-machines-in-yyz-over-6pn-since-13-55-utc/28688)
**Author:** [@bakedbean](https://community.fly.io/u/bakedbean)\ **Replies:** 2\ **Last updated:** [September 23, 2026, 2:50pm UTC](https://community.fly.io/t/cant-reach-two-postgres-machines-in-yyz-over-6pn-since-13-55-utc/28688 "2026-09-23T14:50:34Z")
Since about 13:55 UTC on Sep 23, two Postgres machines in yyz can’t be reached over the private network. It looks like both are on the same host. Both pass their health checks and accept connections locally, but TCP to t… --- ## [Intermittent 10–60 s 6PN blackouts between two Machines in gru (app ↔ Postgres Flex)](https://community.fly.io/t/intermittent-10-60-s-6pn-blackouts-between-two-machines-in-gru-app-postgres-flex/28620)
**Author:** [@felipemesquita](https://community.fly.io/u/felipemesquita)\ **Replies:** 11\ **Last updated:** [September 23, 2026, 12:06am UTC](https://community.fly.io/t/intermittent-10-60-s-6pn-blackouts-between-two-machines-in-gru-app-postgres-flex/28620 "2026-09-23T00:06:15Z")
Two Machines in the same org (pedale-sempre) and the same region (gru), talking over 6PN: API app pedale-sempre-api, machine 28747327c61958 (shared-cpu-1x, 1 GB, Node 24, always on) Postgres Flex app pedale-sempre-db, … --- ## [Machine unreachable from WireGuard peer but healthy and reachable from other apps in the same org](https://community.fly.io/t/machine-unreachable-from-wireguard-peer-but-healthy-and-reachable-from-other-apps-in-the-same-org/28666)
**Author:** [@SANTI-gdi-operacione](https://community.fly.io/u/SANTI-gdi-operacione)\ **Replies:** 6\ **Last updated:** [September 21, 2026, 5:16pm UTC](https://community.fly.io/t/machine-unreachable-from-wireguard-peer-but-healthy-and-reachable-from-other-apps-in-the-same-org/28666 "2026-09-21T17:16:06Z")
One machine in our DEV org became unreachable from our WireGuard peer, while staying perfectly healthy inside the private network. Every other machine in the same org, over the same peer, works fine at the same moment. … --- ## [Managed Postgres and backup data physical location](https://community.fly.io/t/managed-postgres-and-backup-data-physical-location/28671)
**Author:** [@Jjprusk](https://community.fly.io/u/Jjprusk)\ **Replies:** 2\ **Last updated:** [September 21, 2026, 10:42am UTC](https://community.fly.io/t/managed-postgres-and-backup-data-physical-location/28671 "2026-09-21T10:42:09Z")
For our application state regulators require us to state in writing where our records and their backups are physically stored. We currently set the database (and Tigris) to a U.S. region but for the Postgres backup it’s … --- ## [Managed Postgres is now in the Machines API](https://community.fly.io/t/managed-postgres-is-now-in-the-machines-api/28640)
**Author:** [@tripledoublev](https://community.fly.io/u/tripledoublev)\ **Replies:** 0\ **Last updated:** [September 15, 2026, 5:26pm UTC](https://community.fly.io/t/managed-postgres-is-now-in-the-machines-api/28640 "2026-09-15T17:26:33Z")
The Machines API now supports Managed Postgres (MPG). Using a Fly API token, you can create, inspect, fork, restore, and delete clusters through api.machines.dev/v1/postgres. The API also covers backups, extensions, dat… --- ## [Does MPG support TLS, or only 6PN encryption?](https://community.fly.io/t/does-mpg-support-tls-or-only-6pn-encryption/28616)
**Author:** [@anthonypalmeira](https://community.fly.io/u/anthonypalmeira)\ **Replies:** 6\ **Last updated:** [September 9, 2026, 7:05pm UTC](https://community.fly.io/t/does-mpg-support-tls-or-only-6pn-encryption/28616 "2026-09-09T19:05:28Z")
Trying to use MPG pooled connections with hostname-authenticated TLS (sslmode=verify-full) from a Fly Machine. MPG v1 Pooled endpoint negotiates TLS 1.3, but serves: private postgres-operator-ca, absent from Debian sy… --- ## [extension request: pgrouting](https://community.fly.io/t/extension-request-pgrouting/28601)
**Author:** [@paularmstrong](https://community.fly.io/u/paularmstrong)\ **Replies:** 0\ **Last updated:** [September 5, 2026, 5:32pm UTC](https://community.fly.io/t/extension-request-pgrouting/28601 "2026-09-05T17:32:56Z")
Would it be possible to get the pgrouting extension available? This was previously requested but there was no response and the thread was auto-locked :frowning: Extension request: pgRouting for Managed Postgres --- ## [How can I debug performance issues on an unmanaged PG cluster?](https://community.fly.io/t/how-can-i-debug-performance-issues-on-an-unmanaged-pg-cluster/28500)
**Author:** [@anujeet\_swain](https://community.fly.io/u/anujeet_swain)\ **Replies:** 17\ **Last updated:** [August 28, 2026, 3:34pm UTC](https://community.fly.io/t/how-can-i-debug-performance-issues-on-an-unmanaged-pg-cluster/28500 "2026-08-28T15:34:16Z")
App: postgres-hose-2025, region sin. Primary machine e825411f01e998, replica e82de15a213148 stayed healthy throughout. Primary’s pg/role checks flapped 0/3→3/3 in a loop for a while. Logs showed sorry, too many clients … --- ## [Does managed Postgres backup to the managed region - SYD?](https://community.fly.io/t/does-managed-postgres-backup-to-the-managed-region-syd/28548)
**Author:** [@danielc](https://community.fly.io/u/danielc)\ **Replies:** 1\ **Last updated:** [August 26, 2026, 1:44pm UTC](https://community.fly.io/t/does-managed-postgres-backup-to-the-managed-region-syd/28548 "2026-08-26T13:44:47Z")
Just checking MPG backups are stored in sydney or one of the au southeast s3 containers? --- ## [Running your side-project databases on the cheap](https://community.fly.io/t/running-your-side-project-databases-on-the-cheap/28541)
**Author:** [@halfer](https://community.fly.io/u/halfer)\ **Replies:** 6\ **Last updated:** [August 24, 2026, 7:14pm UTC](https://community.fly.io/t/running-your-side-project-databases-on-the-cheap/28541 "2026-08-24T19:14:54Z")
I thought I’d start a thread for readers who’re working on a side-project that will, one day, take over the world. You might need a relational database, and despite the economies-of-scale promises of the cloud, most thin… --- ## [Scale to zero Postgres for hobby projects](https://community.fly.io/t/scale-to-zero-postgres-for-hobby-projects/12212)
**Author:** [@DAlperin](https://community.fly.io/u/DAlperin)\ **Replies:** 18\ **Last updated:** [August 23, 2026, 8:32am UTC](https://community.fly.io/t/scale-to-zero-postgres-for-hobby-projects/12212 "2026-08-23T08:32:06Z")
Starting with flyctl v0.0.520 you’ll be given the option to have your db scale to zero if you are creating a shared-cpu-1x single node cluster. The idea behind this is that you can have hobby projects scale to zero when … --- ## [Recover pending\_destroy volumes from accidentally deleted parkwave-db app](https://community.fly.io/t/recover-pending-destroy-volumes-from-accidentally-deleted-parkwave-db-app/28514)
**Author:** [@kkcom](https://community.fly.io/u/kkcom)\ **Replies:** 8\ **Last updated:** [August 19, 2026, 5:01pm UTC](https://community.fly.io/t/recover-pending-destroy-volumes-from-accidentally-deleted-parkwave-db-app/28514 "2026-08-19T17:01:42Z")
I accidentally destroyed our production Legacy Postgres app parkwave-db approximately 15 hours ago. Organization: Personal Estimated deletion time: 2026-08-18 13:00 UTC Region: likely sin The Usage dashboard still sh… --- ## [You can now restore your MPGv1 backups as a v2 cluster](https://community.fly.io/t/you-can-now-restore-your-mpgv1-backups-as-a-v2-cluster/28466)
**Author:** [@akshit-fly](https://community.fly.io/u/akshit-fly)\ **Replies:** 0\ **Last updated:** [August 11, 2026, 3:42am UTC](https://community.fly.io/t/you-can-now-restore-your-mpgv1-backups-as-a-v2-cluster/28466 "2026-08-11T03:42:05Z")
While restoring a backup of a MPGv1 cluster, you can pick MPGv2 as your restore destination. For now, this is only available on the UI. Will be available in flyctl soon. --- ## [fly pg create --fork-from doesn't work? Field 'node' doesn't exist on type 'Queries'](https://community.fly.io/t/fly-pg-create-fork-from-doesnt-work-field-node-doesnt-exist-on-type-queries/28397)
**Author:** [@JonasCz](https://community.fly.io/u/JonasCz)\ **Replies:** 2\ **Last updated:** [August 10, 2026, 6:52pm UTC](https://community.fly.io/t/fly-pg-create-fork-from-doesnt-work-field-node-doesnt-exist-on-type-queries/28397 "2026-08-10T18:52:31Z")
When I run fly pg create --name new-db-app-name --fork-from old-db-app-name --verbose --region iad I get Error: failed to run query($id: ID!) { volume: node(id: $id) { ... on Volume { app { name } } } }: Field 'node' d… --- ## [Postgres DBConnection and other errors on Fly](https://community.fly.io/t/postgres-dbconnection-and-other-errors-on-fly/5527)
**Author:** [@sheharyar](https://community.fly.io/u/sheharyar)\ **Replies:** 12\ **Last updated:** [July 23, 2026, 9:00pm UTC](https://community.fly.io/t/postgres-dbconnection-and-other-errors-on-fly/5527 "2026-07-23T21:00:44Z")
We just migrated our app’s Postgres database from DigitalOcean to Fly.io yesterday and have suddenly started seeing a large number of DBConnection and other Postgrex related errors that we never encountered on DigitalOc… --- ## [MPG security limitations](https://community.fly.io/t/mpg-security-limitations/28322)
**Author:** [@hagmonk](https://community.fly.io/u/hagmonk)\ **Replies:** 0\ **Last updated:** [July 20, 2026, 10:40pm UTC](https://community.fly.io/t/mpg-security-limitations/28322 "2026-07-20T22:40:39Z")
Hey all. It seems that MPG doesn’t permit management of users or roles outside of the basics provided by flyctl and the admin UI. This has turned out to be awkward! It means that as soon as I have two applications that n… --- ## [MPGv2: New Regions and GA](https://community.fly.io/t/mpgv2-new-regions-and-ga/28321)
**Author:** [@juliana](https://community.fly.io/u/juliana)\ **Replies:** 0\ **Last updated:** [July 20, 2026, 10:34pm UTC](https://community.fly.io/t/mpgv2-new-regions-and-ga/28321 "2026-07-20T22:34:37Z")
Hello folks, We’ve rolled out MPGv2 to 7 (!) new regions: GRU, LAX, SJC, SIN, NRT, SYD, and LHR. MPGv2 has proven significantly more stable and faster in production, so in the upcoming days we will move MPGv2 to GA and… --- ## [MPGv2 has forking in beta](https://community.fly.io/t/mpgv2-has-forking-in-beta/28292)
**Author:** [@akshit-fly](https://community.fly.io/u/akshit-fly)\ **Replies:** 0\ **Last updated:** [July 16, 2026, 1:42pm UTC](https://community.fly.io/t/mpgv2-has-forking-in-beta/28292 "2026-07-16T13:42:38Z")
You can now fork your Managed Postgres v2 clusters. Forking is almost as fast as v2 cluster creates (well almost, its a tiny bit slower). Its MUCH faster than a full backup restore. In your v2 dashboard, you’ll now see … --- ## [MPGv2: "Delete database" returns 400, and no flyctl/API way to drop a DB](https://community.fly.io/t/mpgv2-delete-database-returns-400-and-no-flyctl-api-way-to-drop-a-db/28149)
**Author:** [@nikolacicmil](https://community.fly.io/u/nikolacicmil)\ **Replies:** 4\ **Last updated:** [July 1, 2026, 3:26pm UTC](https://community.fly.io/t/mpgv2-delete-database-returns-400-and-no-flyctl-api-way-to-drop-a-db/28149 "2026-07-01T15:26:37Z")
Hi team, I’m hitting two related issues trying to delete an individual database from a Managed Postgres (MPGv2) cluster, and wanted to report them together since they compound. Problem 1 — Dashboard “Delete database” r… --- ## [MPGv2 is available in more regions](https://community.fly.io/t/mpgv2-is-available-in-more-regions/28187)
**Author:** [@akshit-fly](https://community.fly.io/u/akshit-fly)\ **Replies:** 0\ **Last updated:** [June 30, 2026, 2:06pm UTC](https://community.fly.io/t/mpgv2-is-available-in-more-regions/28187 "2026-06-30T14:06:29Z")
Some eagle eyed users might’ve noticed we rolled out MPGv2 in IAD and FRA yesterday. Today AMS and ORD joins that list! Regions supported by MPGv2 include AMS DFW FRA IAD ORD YYZ We’ll roll it out to more regions in … --- ## [Postgres Flex: A former primary DB machine came back as a zombie and kept serving read-only writes](https://community.fly.io/t/postgres-flex-a-former-primary-db-machine-came-back-as-a-zombie-and-kept-serving-read-only-writes/28167)
**Author:** [@docNoodle](https://community.fly.io/u/docNoodle)\ **Replies:** 2\ **Last updated:** [June 29, 2026, 3:34pm UTC](https://community.fly.io/t/postgres-flex-a-former-primary-db-machine-came-back-as-a-zombie-and-kept-serving-read-only-writes/28167 "2026-06-29T15:34:48Z")
Cluster: onth-database, postgres-flex, 3 machines (2× sin, 1× nrt), image flyio/postgres-flex:17.2 v0.0.66 at the time. Impact: ~3h of intermittent write failures on our API (PG::ReadOnlySqlTransaction + PG::ConnectionB… --- ## [PostGIS plain Fly app rejects password over .internal, pg\_hba.conf issue?](https://community.fly.io/t/postgis-plain-fly-app-rejects-password-over-internal-pg-hba-conf-issue/28161)
**Author:** [@Amouraos](https://community.fly.io/u/Amouraos)\ **Replies:** 0\ **Last updated:** [June 25, 2026, 1:40pm UTC](https://community.fly.io/t/postgis-plain-fly-app-rejects-password-over-internal-pg-hba-conf-issue/28161 "2026-06-25T13:40:39Z")
Postgres auth fails over the private network even though the same password works locally on the DB machine itself. Looking for the right pg\_hba.conf fix for a plain Fly Postgres app (not Managed Postgres). Setup: DB a… [Next page](https://community.fly.io/tag/postgres/18.md?match_all_tags=true&page=1&tags%5B%5D=postgres)