X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D057611F622A for ; Fri, 7 Apr 2006 01:55:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09505-05 for ; Fri, 7 Apr 2006 01:55:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id 1FE3311F6226 for ; Fri, 7 Apr 2006 01:55:06 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id c31so209288nfb for ; Thu, 06 Apr 2006 21:55:06 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=V95MPYFUdI+N2BgWXYYuWl1noNw45Z2hTvBEPm9h62dMOeOgsbEHyx/WkAvDLCfalyV8aH06WSAG1gquvRJd7ZwLpC51OIN7fOuMPRajJ6LI/rSA3Cv+E6dR4osBOgTzCSDSmH7cRuZGp69uGT9+2+Ncq10UnYDWipdt+sjSfuk= Received: by 10.49.20.12 with SMTP id x12mr193370nfi; Thu, 06 Apr 2006 21:55:06 -0700 (PDT) Received: by 10.49.27.16 with HTTP; Thu, 6 Apr 2006 21:55:06 -0700 (PDT) Message-ID: Date: Fri, 7 Apr 2006 10:25:06 +0530 From: "Rajesh Kumar Mallah" To: "=?ISO-8859-1?Q?Sidar_L=F3pez_Cruz?=" Subject: Re: Storage and Backup Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200604/70 X-Sequence-Number: 21239 On 4/7/06, Sidar L=F3pez Cruz 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=EDdar LC. > > > > ________________________________ > MSN Amor Busca tu =BD naranja