pg_dump -h <source_host> -U <source_user> <source_db> | psql -h <destination_host> -U <destination_user> <destination_db>