itzmidinesh
Hi! 
I’m currently working on a project that requires using the Temporal Tables extension in PostgreSQL, and I’m wondering if it’s possible to install custom extensions on Fly.io’s managed PostgreSQL databases?
I’ve experienced that Fly.io offers great support for Elixir applications, but I’m running into a roadblock because Temporal Tables isn’t available by default in the Fly.io database.
For context:
- Temporal Tables allow us to track historical versions of data, making it easy to query past states of data without manually managing timestamps.
- It’s a really powerful feature for applications that need to store and query time-varying data.
I’m curious if anyone has experience installing custom extensions or if there are any workarounds available for using this feature on Fly.io’s PostgreSQL. Or, if it’s not currently possible, do you have any suggestions on how best to approach this while leveraging Fly.io’s infrastructure for Elixir apps?
Looking forward to hearing your thoughts! 
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Courses that'll move you from confusion to "Aha, now I get it!"
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixirconf-us
- #ai
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Master modern tools, write cleaner code, and tackle real-world challenges.
Bringing learning, work and compliance together since 1987.
**Building the future of software with AI, trust, and human connection.**
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 1- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
itzmidinesh
I have been considering switching to Neon’s serverless Postgres for production, but unfortunately, they don’t support the installation of the extension either.
Given the complexity involved in installing the extension, I am exploring an alternative approach that doesn’t rely on extensions, using this repository: GitHub - nearform/temporal_tables: Postgresql temporal_tables extension in PL/pgSQL, without the need for external c extension. · GitHub
I wanted to share this here in case someone else encounters a similar issue in the future.