Search Postgresql Archives

Re: pg_Restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.albe@xxxxxxxxxx
> To: udayabhanu1984@xxxxxxxxxxx; chris.travers@xxxxxxxxx
> CC: magnus@xxxxxxxxxxxx; francois@xxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx
> Subject: RE: 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux