Re: Storage and Backup

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема Re: Storage and Backup
Дата
Msg-id a97c77030604062155q33a97ff8jcc9760aab8188bc8@mail.gmail.com
обсуждение исходный текст
Ответ на Storage and Backup  (Sidar López Cruz <sidarlopez@hotmail.com>)
Список pgsql-admin
On 4/7/06, Sidar López Cruz <sidarlopez@hotmail.com> wrote:
>
> It's hard for PostgreSQL to administrate and serve a database with over
> 150GB of information?
> It's complicated to backup and restore a database with this size?
> It's there a program or a procedure to backup and restore this kind of
> databases?

PITR is recommended for backup of such databases as it does
not involves dumping of entrie data everytime.

rsyncing pgdatadir while refreshing the base backup can minimise
the time for syncing as it has an intelligent algo.

Regds
Rajesh Kumar Mallah.

> What operating system do you recommend to use (Windows 2003 or Linux
> Ubuntu)?
>
>
> Thanks for you very important help !!!
> Sídar LC.
>
>
>
> ________________________________
> MSN Amor Busca tu ½ naranja

В списке pgsql-admin по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Error Handling with COPY command
Следующее
От: "Evert Daman"
Дата:
Сообщение: database owner gone?