search

elestio-examples / supabase

Deploy Supabase with CI/CD on Elestio
6 stars 0 forks source link

Update Supabase images #1

Open rickylabs opened 1 year ago

rickylabs commented 1 year ago

Hi we are using this template at our company and we would like to know if an images update is planned anytime soon ?

There are awesome new features now available in the self hosted version of Supabase that we would love to use !

jbenguira commented 1 year ago

We have just updated the template ☺️

rickylabs commented 1 year ago

Thanks for that quick update but i'm afraid that supabase storage is misconfigured because I'm unable to create a bucket

getting below error: storage_1 | DBError: new row violates row-level security policy

and I'm not able to update policies for supabase_storage_admin in Studio

AmsellemJoseph commented 1 year ago

Hey @rickylabs,

We have fixed the issue with creating bucket, and also for uploading files 🙂

rickylabs commented 1 year ago

Many thanks it's running fine on my end, I just noticed that the db image is still using supabase/postgres:14 and this prevent us using features such as wrappers with stripe. Any guidance on how to upgrade safely our db and this image ?

rickylabs commented 1 year ago

Hello everyone,

I am excited to share that I have successfully upgraded the Supabase starter repository provided by Elest.io to PostgreSQL 15, along with implementing several other enhancements. Here's a summary of the changes and the process I followed:

Upgrades and Enhancements:

  1. PostgreSQL Version: The PostgreSQL version was upgraded from 14.1.0.106 to 15.1.0.109, providing us with the latest features and improvements from PostgreSQL.

  2. Supabase Studio Version: The Supabase Studio version was updated from 20230729-a7e6617 to 20230803-15c6762, ensuring we have the most recent features and fixes from Supabase Studio.

  3. Storage API Version: The Storage API version was updated from v0.26.1 to v0.41.5, which likely includes various enhancements and bug fixes.

  4. Edge Runtime Version: The Edge Runtime version was updated from v1.7.2 to v1.9.0, providing us with the latest capabilities of the Edge Runtime.

  5. Storage Backend and S3 Configurations: New environment variables related to the storage backend and S3 configurations were added. This allows for more flexible and robust storage management.

  6. Image Transformation: The ability to perform image transformations was enabled, which can be a powerful feature for handling image data.

  7. Imgproxy Service: A new Imgproxy service was added for image processing, further enhancing our capabilities in handling image data.

PostgreSQL Upgrade Process:

The upgrade process from PostgreSQL 14 to 15 involved a few key steps:

  1. Data Dump: I first dumped the data from the existing PostgreSQL 14 setup using the pg_dump command. This created a backup of the data that could be used to populate the new PostgreSQL 15 instance.

  2. External Volume Setup: I set up a new external volume for the PostgreSQL 15 instance. This provided a separate storage space for the new database.

  3. Data Import: I then imported the dumped data into the new PostgreSQL 15 instance using the pg_restore command. This populated the new database with the existing data.

  4. Verification: Finally, I verified that the data was correctly imported and that the new PostgreSQL 15 instance was working as expected.

The updated repository reflecting these changes can be found here: GitHub Link

Please note that this is an ongoing project, and further optimizations will be made to enhance the performance and usability of the setup. The README file in the repository will be updated with necessary instructions and information as these improvements are implemented.

I would like to take this opportunity to express my gratitude to the Elest.io team for creating such an amazing tool. It has significantly simplified the management of my services and has made my life much easier. Their continuous efforts to improve and enhance the platform are truly commendable.

I hope this information proves helpful to anyone looking to upgrade their PostgreSQL version or integrate additional features into their Supabase setup. Please feel free to ask any questions or share your thoughts on this process.

AmsellemJoseph commented 1 year ago

Hey @rickylabs,

First, thanks a lot for your contribution!!

We have updated our template with the latest images of supabase and also added imgproxy, so from now, you can handling your images data.