Using Supabase with managed Postgres (e.g. AWS RDS)
Hi everyone,
I was considering using Supabase (self-hosted) for a new enterprise project. One of the requirements is that the database must be able to run on a managed service (e.g., Amazon RDS).
While the documentation states that you can simply connect to an external database, I’ve found that this doesn’t really work without the Supabase Postgres image. The main issue isn’t just migrations but also missing extensions, which typically cannot be installed on a managed database.
This leads me to the conclusion that Supabase cannot be run with a standard Postgres instance. Is this assumption correct, or does anyone here have additional insights?
Either way, I thought this thread could serve as a place to discuss similar requirements.
2 Replies
AWS RDS is known to be locked down and don't allow for certain extensions, this isn't to say you cannot use Supabase with standard Postgres instances. RDS isn't a standard Postgres instance hence why you can't install certain extensions. You can do so with any other Postgres instance you setup yourself. You can even try this with a local docker instance of Postgres and you will see it works.
I did not want to offend anyone, however, as I said, we must use Managed Hosting and usually this means, that there is no way to install custom extensions. This is true for AWS, Google Cloud and I think most of the currently used Cloud Solutions out there.