Search for a command to run...
In just 6 easy steps
No comments yet. Be the first to comment.
In this serie we'll be covering some topics like: - Account creation - Database creation and management - Storage(buckets) - Authentication - Edge Functions and more!
Introduction In today's digital world, user experience is key to the success of any web or mobile application. Users expect seamless, intuitive, and secure authentication processes that protect their personal information. That's where Supabase Auth U...
Low-code platforms can be excellent for validating an idea. The risk begins when a temporary launch stack becomes permanent infrastructure for a growing product.
A practical, opinionated baseline for securing fresh Debian/Ubuntu VPS servers before deploying real apps.
How to enable HTTPS on localhost with Vite and mkcert
There are two kinds of developers: those who fear regex, and those who use it like a superpower. The funny part? It’s the same tool — the difference is perspective.Most people think of regex as the thing you use to validate emails, phone numbers, or ...
Why accessibility is everyone’s responsibility
Recently, I've seen many people asking how to move their PostgreSQL database to Supabase. They want a clear guide to help them switch without losing data or causing too much downtime. The process is straightforward, let me show you!
A local/remote PostgreSQL database you wanna migrate to Supabase.
A Supabase account (you can sign up for free).
Basic knowledge of PostgreSQL commands.
For this example, I have created a table called User with the fields: id, name, lastname and age, really simple, just for demonstration purposes:
Before making any changes, it's crucial to back up your local database to prevent any data loss.
Use the pg_dump command:
pg_dump 'postgres://{user}:{password}@{hostname}:{port}/{database-name}' > database_dump.dump
Replace the placeholders with your local database details.
Alternatively, you can use any app that allows you to manage databases like TablePlus, which is the one I'll be using in this example:
As you can see I have two connections one pointing to my local database and another to the Supabase remote connection. To create a dump just click on the Backup option, select the local connection, and the database name and click the Start backup button as shown in the picture:
This will ask you to save a .dump file.
The next step would be the Backup importation. For this, we'll need to have a Supabase account created, if you already have one:
Navigate to the Supabase Dashboard.
Click on "New Project" and fill in the required details.
If you're having trouble with it, I have a Supabase starter guide that will assist you in completing the task.
Now, you'll upload the backup to Supabase.
Use the pg_restore command:
pg_restore -d 'postgres://{user}:{password}@{hostname}:{port}/{database-name}' database_dump.dump
Replace the placeholders with the details provided by Supabase for your project and the path to your backup file.
Again, you can achieve this with TablePlus easily and the steps are mostly identical to the dump process. This time click on the Restore option, select the previously created Supabase connection, and the database name and click the Start restore button as shown in the picture:
After the restoration process, navigate to the Table section in your Supabase dashboard. You'll see there all the tables of your database.
Supabase provides a robust role-based permission system as you could see in the previous step. Make sure you set the correct permissions to each table in your database, it will make it more secure
Go to the "Authentication" section.
Adjust the roles and permissions to match your application's requirements.
If you have an application using the database:
Update the connection strings to point to the Supabase database.
Test the application to ensure data retrieval and other operations work seamlessly.
That's it!
Migrating your local PostgreSQL database to Supabase is a straightforward process that can offer numerous benefits, including scalability, real-time capabilities, and a user-friendly interface. By following the steps outlined in this article, you can smoothly transition your database to the cloud and leverage the power of Supabase for your projects.