Clone Postgres DB

From Flo's Knowledge in a Nutshell

Jump to: navigation, search
CREATE DATABASE copy;
pg_dump -h  localhost original -U postgres | psql -h localhost -d copy -U postgres
Personal tools