Re: [GENERAL] pg_Restore

[bhanu udaya]

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 RegardsRadha Krishna
 > From: laurenz.a...@wien.gv.at
> To: udayabhanu1...@hotmail.com; chris.trav...@gmail.com
> CC: mag...@hagander.net; franc...@teksol.info; pgsql-general@postgresql.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