postgresql query to backup and restore databases from one remote server to another & query

postgresql query to backup and restore databases from one remote server to another
& Query
update table on the basis of table in other database