How do I manually back up a supabase database via CLI?
I installed PostgreSQL via Homebrew (pg_dump --version: 14.19). I'm unable to back up my data. After that, I'd like to restore the data. I have users. The data is protected with Row Level Security (RLS).
postgresql://postgres:[YOUR-PASSWORD]@db.[YOUR-DB].supabase.co:5432/postgres
no such file or directory: postgresql://postgres:[YOUR-PASSWORD]@db.[YOUR-DB].supabase.co:5432/postgres
pg_dump --dbname="postgresql://postgres:[YOUR-PASSWORD]@db.[YOUR-DB].supabase.co:5432/postgres" --disable-triggers > database-dump.sql
pg_dump: error: could not translate host name "db.[YOUR-DB].supabase.co" to address: nodename nor servname provided, or not known
pg_dump --dbname="postgresql://postgres.[YOUR-DB]@aws-0-us-east-1.pooler.supabase.com:5432/postgres" --disable-triggers > database-dump.sql
pg_dump: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (XX.XX.XX.XXX), port 5432 failed: FATAL: Tenant or user not found
connection to server at "aws-0-us-east-1.pooler.supabase.com" (XX.XX.XX.XXX), port 5432 failed: FATAL: Tenant or user not found
Thanks