CREATE DATABASE copy; pg_dump -h localhost original -U postgres | psql -h localhost -d copy -U postgres