Re: Storage and Backup - Mailing list pgsql-admin

From Rajesh Kumar Mallah
Subject Re: Storage and Backup
Date
Msg-id a97c77030604062155q33a97ff8jcc9760aab8188bc8@mail.gmail.com
Whole thread Raw
In response to Storage and Backup  (Sidar López Cruz <sidarlopez@hotmail.com>)
List 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 by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Error Handling with COPY command
Next
From: "Evert Daman"
Date:
Subject: database owner gone?