Hi. Not sure if the fastest, but the first that comes up to my mind is using pg_dump and psql. First you create your new database, then you run this(replacing as needed):
pg_dump OLDDB | psql NEWDB
Saludos,
Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.
Oficina: (+51-1) 3377813 | Cel.: (+51) 995540103 | RPC: (+51) 954183248
Website: www.ocs.pe
Sent from my Sony Xperia™ smartphone
---- Sathish Kumar wrote ----
Hi All,
I would like to duplicate our existing db on the same server, what will be the faster way to achieve it.
DB size is around 300gb.