To copy a database from server1 to server2, you might use which of the following:
- pg_mv -h server1 database | pgsql -h server2 database
- pg_dump -h server1 database > pgsql -h server2 database
- pg_copy -h server1 database | psql -h server2 database
- pg_dump -h server1 database | psql -h server2 database
Correct Answer:
D.pg_dump -h server1 database | psql -h server2 database
need an explanation for this answer? contact us directly to get an explanation for this answer