| From: | Alban Hertroys <haramrae(at)gmail(dot)com> |
|---|---|
| To: | bhanu udaya <udayabhanu1984(at)hotmail(dot)com> |
| Cc: | Chris Travers <chris(dot)travers(at)gmail(dot)com>, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, Magnus Hagander <magnus(at)hagander(dot)net>, François Beausoleil <francois(at)teksol(dot)info>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_Restore |
| Date: | 2013-01-21 15:22:25 |
| Message-ID: | CAF-3MvMY77ZteBw5XSTnyPJVYz9gmvd3Hc0yCQRtWZ2b5PD5_Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
On 21 January 2013 16:10, bhanu udaya <udayabhanu1984(at)hotmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2013-01-21 16:10:16 | Re: pg_Restore |
| Previous Message | Albe Laurenz | 2013-01-21 15:19:45 | Re: pg_Restore |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2013-01-21 15:26:11 | Yet Another Timestamp Question: Time Defaults |
| Previous Message | Albe Laurenz | 2013-01-21 15:19:45 | Re: pg_Restore |