Re: pg_Restore - Mailing list pgsql-general

From Alban Hertroys
Subject Re: pg_Restore
Date
Msg-id CAF-3MvMY77ZteBw5XSTnyPJVYz9gmvd3Hc0yCQRtWZ2b5PD5_Q@mail.gmail.com
Whole thread Raw
In response to Re: pg_Restore  (bhanu udaya <udayabhanu1984@hotmail.com>)
List pgsql-general
On 21 January 2013 16:10, bhanu udaya <udayabhanu1984@hotmail.com> wrote:
Can you please let me know the procedure for Template.

As they say, Google is your friend.

The basic principle is this: You create a read-only (template) version of your sample database and use that as a template for the creation of new ones. Of course, now you have another copy of the database stored, which takes up another 9.5GB of disk space, but that's not much on modern systems (oh wait, Windows & 4GB memory?...)

pg_dump would probably be quite a lot faster on a less limited system - databases like memory and fast raid arrays for disks.

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: pg_Restore
Next
From: Rich Shepard
Date:
Subject: Yet Another Timestamp Question: Time Defaults