CLONE POSTGRES DATABASE HOW TO
CLONE POSTGRES DATABASE PASSWORD

To complete the onboarding, click on Review and Save and proceed to the dashboard.Ĭreate a snapshot of your production database. If there are any additional columns that hold data you would like to anonymise, you can click on the respective column name and provide a replacement value for the data in that column. Exclude any non-required table data (such as logs) and extensions and view your columns.Īt this point, Snaplet will automatically detect any columns that have Personally Identifiable Information (PII) and mark them in purple. Alternatively, you can select a given schema and exclude only specific tables from that particular schema. You are able to exclude an entire schema by clicking on the drop-down at the top, selecting the schema you would like to exclude and clicking ‘Exclude schema’. The next step is to exclude any schemas that you do not require. Note that whatever connection string you provide here will be that of your Data Source – essentially the production database in a real-life scenario

CLONE POSTGRES DATABASE HOW TO

Snaplet has a guide in their documentation on how to do so here.

Snaplet will prompt you to only provide read-only access to your database. You’ll have to confirm providing Snaplet access to your database.

CLONE POSTGRES DATABASE PASSWORD

The password is the same password you used when creating the Supabase project. Find the 'Connection string' in Supabase via Organization > Project > Settings > Database > Connection string (at the bottom of the page). Once you have successfully signed up for a new account, create a team, and start by connecting to your Supabase project.Įnter the credentials of your production Supabase project. Navigate to and sign up for a new account (it’s free). To create a read-only role across all schemas you can checkout the Snaplet docs Step 2: Copying your production database 2.1. A read-only role in Production (recommended): This can be done by running the following statements on Supabase via Organization > SQL Editor > + New Query.A development Supabase project's connection string: Same steps as above, but a different project/environment.A production Supabase project's connection string: These can be found in Supabase via Organization > Project > Database > Connection Pooling > Connection string.

Clone postgres database