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
Sathish Kumar wrote:
> I would like to duplicate our existing db on the same server, what will be
> the faster way to achieve it.
If it is in the same database cluster, you can use
CREATE DATABASE newdb TEMPLATE olddb;
Make sure nobody is connected to "olddb" when you do that.
If you want t
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.
