pg_dump: Error - could not translate host name to address
I am trying to save my data using pg_dump with my direct connection string like so (in
C:\Program Files\PostgreSQL\17\bin>):
.\pg_dump --schema-only --no-privileges --no-owner "postgresql://postgres:<MY_PASSWORD>@db.blahblahblah.supabase.co:5432/postgres"
I get the error pg_dump: error: could not translate host name "db.blahblahblah.supabase.co" to address: Name or service not known
I tried using https and that didn't work either.3 Replies
like-gold•7mo ago
We have a guide for this:
https://neon.tech/docs/import/migrate-from-supabase
Let me know if these instructions do not work for you.
There's also a logical replication guide for replicating data from Supabase, but it requires paying for an a Supabase add-on for an IPv4 address.
https://neon.tech/docs/guides/logical-replication-supabase-to-neon
Neon
Migrate from Supabase to Neon Postgres - Neon Docs
This guide describes how to migrate a database from Supabase to Neon Postgres. We use the pg_dump and pg_restore utilities, which are part of the Postgres client toolset. pg_dump works by dumping both...
Neon
Replicate data from Supabase - Neon Docs
This guide describes how to replicate data from Supabase to Neon using native Postgres logical replication. The steps in this guide follow those described in Replicate to another Postgres database usi...
deep-jade•7mo ago
Hi @Raurok,
To create a schema only dump of your source database using your Supabase connection string (make sure it is Direct connection string OR Session pooled connection string [NOT Transaction pooled connection]) using the following command:
conscious-sapphireOP•7mo ago
I don’t think this will work cos supabase makes u pay for directions or something
I will try all suggestions soon thanks
Thank you! It seems that using the session connection string worked.