Clone PSQL database to different machine

clonepsql.md

Assume you want to clone all data of table Abc into a database in a different machine.

1. At src machine:

PGPASSWORD=password sudo pg_dump --host localhost --port 5432 --username username --format plain --verbose --file '/tmp/Abc.bak' --table Abc databasename

2. Copy file to dst machine.

3. At dst machine:

IMPORTANT : existing data will be erased

PGPASSWORD=password psql databasename username < Abc.bak