PostgreSQL copy database within the same server

CREATE DATABASE targetdb WITH TEMPLATE sourcedb;

Postgresql Copy database to another server

pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname

or

pg_dump -C -h remotehost -U remoteuser dbname | psql -h localhost -U localuser dbname