> $ ssh 81.50.12.18 "pg_dump -Z0 -Fc -ibv -U myuser mydb" | gzip -9 Alexander, 1. My database size seems to be appox 1 GB and download speed is approx 600 kb/s. Your solution requires 4.5 hours download time since 1 GB of data must be downloaded. 2. I have only 5432 port open to public internet on server used by Postgres. Your solution requires ssh port to be opened also but sysadmins refuce to configure routers for second port. How to use your solution in those cases ? Andrus.
