Hi All
I want to duplicate the existing database , after reading documentation I
used below command which just created database, but did not create data
CREATE DATABASE standby TEMPLATE template0;
my database is 35gb so dump and psql will take longer hours
is there an fastest way to copy database on same server , so that I can just
modify pointing to the database and connect to the stanby one to do any
testing ?
--
View this message in context: http://www.postgresql-archive.org/How-to-duplicate-postgres-9-4-database-tp5972442.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.