Обсуждение: Storage and Backup

Поиск
Список
Период
Сортировка

Storage and Backup

От
Sidar López Cruz
Дата:
<div style="background-color:"><div class="RTE">It's hard for PostgreSQL to administrate and serve a database with over
150GBof information?</div><div class="RTE">It's complicated to backup and restore a database with this size?</div><div
class="RTE">It'sthere a program or a procedure to backup and restore this kind of databases?</div><div class="RTE">What
operatingsystem do you recommend to use (Windows 2003 or Linux Ubuntu)?</div><div class="RTE"> </div><div
class="RTE"> </div><divclass="RTE">Thanks for you very important help !!!</div><div class="RTE">Sídar LC.</div><div
class="RTE"> </div></div><brclear="all" /><hr />MSN Amor <a href="http://g.msn.com/8HMAES/2752??PS=47575"
target="_top">Buscatu ½ naranja</a> 

Re: Storage and Backup

От
"Rajesh Kumar Mallah"
Дата:
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