Cloning a remote database via SSH

$ ssh user@serverciccio “PGPASSWORD=’passwd’ pg_dump -U user cicciouser | bzip2 -zv9″ | bzcat | psql -U user cicciouser

View this command to comment, vote or add to favourites
View all commands by 0disse0

by David Winterbottom (codeinthehole.com)

Tags: bash cmd Commands shell scripts