How to download large Postgres database to local machine?

1

I have a production Postgres database of 12GB which takes forever to download with pg_dump and the external connection URI.

Is there a better way to do this?

I already tried dumping the database to a file, and then downloading with scp over SSH but it seems the dumped file does not persist between SSH sessions.

2

Hi Marc,

I believe the easiest way to do this is to trigger a manual backup in the dashboard and download the file from there. Is there a reason this won’t work for you?