Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Is the only way to upgrade the instance's Postgres version by contacting support?

Hello <@184390428382986250>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.

**Want to change the title?**
Use the ``/title`` command!

**We have solved your problem?**
Click the button below to archive it.

Apparently the way is take a dump from the current instance and create a new one 👍 https://discord.com/channels/839993398554656828/945665057549844510/945667214718140436

Here are the steps to migrate your project (which will upgrade it to the latest version):  https://supabase.com/docs/guides/database#migrating-between-projects

Let me know if you have any questions on this or need help.  I've done a ton of these 🙂

Unfortunately I have (somehow) 3 free projects so I cannot drop any of my current instances in order to do the dump procedure 😅

Or I _could_ take a dump from my dev instance to get the schema updates, however I feel it's simpler to do it this way 😄

You can do the `pg_dump` part first, then delete the project (if you're confident 🙂 ) then create the new project and restore it.  Just remember to copy down any client_id / secret pairs first from your Oauth page if you're doing third-party Oauth.

If I delete a project, I cannot create a new one since I've used up my quota 😄

Not sure how you got 3 projects -- that must be a bug on our side.

`So manual way via the browser it is` -- what is this?

Yeah, I think it was when the organizational restrictions weren't fully implemented, i.e. I had two organizations and I could create 2 instances for both, and I had created one instance for one organization and two for the other. Now the quota is shared between all your organizations, so I have the third instance there just hanging around 😄

I'm just manually going through my tables in the dev instance and prod instance via the table editor

Thread was archived by <@184390428382986250>. Anyone can send a message to unarchive it.