On 21 January 2013 16:10, bhanu udaya <udayabhanu1984@xxxxxxxxxxx> 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.
