PlanetScale Postgres Extension Not Available

How to fix it

Try these in order — the most common fix is first.

1. 1. Check the supported list

   Copy steps
   1. Open the Postgres extensions docs
   2. Confirm the extension and version match your source
   Did this fix it? Yes No

2. 2. Enable via dashboard

   Copy steps
   1. Database > Extensions
   2. Enable and wait for restart if required
   Did this fix it? Yes No

3. 3. Use a superuser role

   Copy steps
   1. Connect with a role that has superuser privileges
   2. Run CREATE EXTENSION in the public schema if required
   Did this fix it? Yes No

Symptoms

CREATE EXTENSION fails or the extension is missing.

Why it happens

• Extension not on the vetted list
• Extension needs shared memory or a background worker
• Extension must live in the public schema

This guide also covers

• planetscale postgres extensions
• planetscale postgis

Other PlanetScale errors

• PlanetScale Transaction Pool Connection Limit Exceeded
• PlanetScale Foreign Key Constraints Not Working
• PlanetScale Safe Migrations: DDL Statement Rejected
• PlanetScale Prisma Connection Errors
• PlanetScale Query Exceeded Row or Time Limit
• PlanetScale Postgres Import Fails or Is Slow
• PlanetScale Unexpected Bill: Storage, Backups and Transfer
• PlanetScale Connection Errors During Outage