Work: How to Partially Migrate a PostgreSQL database
Assuming you have database on hostA and want to copy it to this host: Create the database on hostB sudo su – postgres “createuser –pwprompt –superuser –createdb newdba -h hostB” createdb -U newdba newdb...