Re: pg_Restore

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: pg_Restore
Дата
Msg-id CAF-3MvMY77ZteBw5XSTnyPJVYz9gmvd3Hc0yCQRtWZ2b5PD5_Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_Restore  (bhanu udaya <udayabhanu1984@hotmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: pg_Restore
Следующее
От: Rich Shepard
Дата:
Сообщение: Yet Another Timestamp Question: Time Defaults