'Dumping from remote server to localhost with postgreSQL

I'm looking for a way to dump a database from a Linux server running Ubuntu to my local Windows machine. I'd like to run the pg_dump command directly on the remote server.

Doing it from my local machine would be something like:

pg_dump -U user -h HOST -p port -v -d database > C:\Users\..\..dmp

But how to do it from the remote server to my local machine? e.g.

remote server > c:\..\..

Thanks.

postgresql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions