Re: Storage and Backup

From: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>
To: Sidar López Cruz <sidarlopez(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Storage and Backup
Date: 2006-04-07 04:55:06
Message-ID: a97c77030604062155q33a97ff8jcc9760aab8188bc8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 4/7/06, Sidar López Cruz <sidarlopez(at)hotmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-04-07 18:39:31 Re: database owner gone?
Previous Message cruise0078 2006-04-07 04:35:21 I have a question?