postgres - time between read replica syncs

Questions / Help
1

Hey folks

had a couple of questions about Postgres support.

  1. What is the latency between the read replicas syncing up with the primary db?
  2. does fly provides unix sockets for the postgres db (assuming the server and the db are in the same region)?
2

Hi @rishav,

You can see the current latency in the “metrics” tab of your postgres app under “Replication Lag”

Fly doesn’t provide unix sockets, you should connect over 6PN networking, preferably using flyctl postgres attach to create a user + database and set the DATABASE_URL secret.