Skip to content

Managed / cloud PostgreSQL environments

Managed PostgreSQL services — AWS RDS, AWS Aurora, Azure Database for PostgreSQL Flexible Server, Google Cloud SQL for PostgreSQL, and similar platforms — do not allow you to place files on the server filesystem, which means CREATE EXTENSION pg_auto_mv is not possible. This is a restriction of the managed service, not of pg_auto_mv.

Because pg_auto_mv is pure SQL, this is not a blocker: the entire extension can be deployed by running its SQL file directly against the database, producing an installation that is functionally identical to CREATE EXTENSION pg_auto_mv — the same schema, types, tables, views, and functions are created, and the pg_relay action registrations are inserted the same way.

See CLOUD_INSTALL.md for the full generic workaround and step-by-step instructions covering:

  • AWS RDS for PostgreSQL
  • AWS Aurora for PostgreSQL
  • Azure Database for PostgreSQL Flexible Server
  • Google Cloud SQL for PostgreSQL
  • Other managed services (DigitalOcean, Neon, Railway, Render, Supabase, Aiven, Tembo, and similar platforms)