Xetera

Restoring a supabase dump to local postgres

Supabase contains a ton of extra schemas, roles and extensions that prevents restoring a local db from a supabase db. There are some tools out there but thery're all tedious to use. Here's how you can do it with a single pg_dump command

pg_dump --exclude-schema graphql --exclude-schema auth --exclude-schema graphql_public \
  --exclude-schema pgsodium --exclude-schema pgbouncer --exclude-schema storage \
  --exclude-schema realtime --exclude-schema vault --exclude-extension pgsodium \
 --exclude-extension pg_graphql --exclude-extension supabase_vault \

	#! /usr/bin/env python3
	import requests
	import os
	import pathlib

	RADARR_TOKEN = os.environ.get("RADARR_TOKEN")
	# directory where hardlinks will be created for renaming purposes
	HARDLINK_TARGET = os.environ.get("HARDLINK_TARGET")
	# DRY_RUN=true to test without touching the filesystem
	DRY_RUN = os.environ.get("DRY_RUN", "false").lower() == "true"

	#! /usr/bin/env python3
	import requests
	import os
	import pathlib

	SONARR_TOKEN = os.environ.get("SONARR_TOKEN")
	# directory where hardlinks will be created for renaming purposes
	HARDLINK_TARGET = os.environ.get("HARDLINK_TARGET")
	# DRY_RUN=true to test without touching the filesystem
	DRY_RUN = os.environ.get("DRY_RUN", "false").lower() == "true"

	// Yes this is vibe coded. It worked fine for me
	package main

	import (
	"encoding/json"
	"fmt"
	"io"
	"net/http"
	"os"
	"path/filepath"