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.
