Hello All,
Can we achieve this template or pg_Restore in less than 20 minutes time. Any more considerations. Kindly reply. Thanks and RegardsRadha Krishna From: udayabhanu1984(at)hotmail(dot)com
To: laurenz(dot)albe(at)wien(dot)gv(dot)at; chris(dot)travers(at)gmail(dot)com
CC: magnus(at)hagander(dot)net; francois(at)teksol(dot)info; pgsql-general(at)postgresql(dot)org
Subject: RE: [GENERAL] pg_Restore
Date: Mon, 21 Jan 2013 21:45:32 +0530
Hello,
Thanks all for the great help. Template is very good option so far seen. It comes little quickly than pg_restore. But, this also takes 40 minutes time.
I am using Windows with 4GB Ram.
Thanks and Regards
Radha Krishna
> From: laurenz(dot)albe(at)wien(dot)gv(dot)at
> To: udayabhanu1984(at)hotmail(dot)com; chris(dot)travers(at)gmail(dot)com
> CC: magnus(at)hagander(dot)net; francois(at)teksol(dot)info; pgsql-general(at)postgresql(dot)org
> Subject: RE: [GENERAL] pg_Restore
> Date: Mon, 21 Jan 2013 15:19:45 +0000
>
> bhanu udaya wrote:
> > Can you please let me know the procedure for Template. Will it restore the data also
> > .
>
> It will create a complete copy of an existing database
>
> The procedure is
> CREATE DATABASE newdb TEMPLATE olddb;
>
> Nobody may be connected to olddb for this to work.
>
> Yours,
> Laurenz Albe