https://supabase.com/ logo
#help
Title
# help
z

Zozo

05/09/2022, 9:32 AM
Hi! I am launching my Supabase powered app to production, for that I need to create a clean copy of my public schema. I can not seem to be able to run pg_dump on the dashboard sql editor. has anyone done this before? any other suggestions on how to have two Supabase projects, one for development and one for production are welcome! Thanks
n

Needle

05/09/2022, 9:32 AM
Hello @Zozo! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User 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.
o

Olyno

05/09/2022, 10:17 AM
Hi You can't use the ``pg_dump`` in the sql editor indeed, but you can use it on your side in any terminal you have. The connection URI is available in settings @Zozo
n

Needle

05/09/2022, 10:17 AM
Zozo (2022-05-09)
o

Olyno

05/09/2022, 10:18 AM
Here is the command i'm using to backup my Supabase database
Copy code
pg_dump -d "<your connection string>" > backup.sql
z

Zozo

05/09/2022, 2:05 PM
thank you! @Olyno I managed to backup through pgAdmin.