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 51DF19DC9DA for ; Wed, 14 Dec 2005 12:11:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09390-01 for ; Wed, 14 Dec 2005 12:11:09 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.203]) by postgresql.org (Postfix) with ESMTP id 50E929DC9D2 for ; Wed, 14 Dec 2005 12:11:08 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so175507nzn for ; Wed, 14 Dec 2005 08:11:07 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=oRZiYjwdClxhgJljU6qIGvMmTWwAphUyiqqoupIIJHg2u9GD1WIhIlmqmIzjG9rGE672RuZvYUScU2+u5F50iOxlwOrbvcj9lfwuJ1ZHEvtcLpWpDX+EwyKBSYNhWt1bNDTkCXYPLAk0Hk2ULv5LVZ3u75t/4/Poyk+0qWnP5yk= Received: by 10.65.59.11 with SMTP id m11mr512941qbk; Wed, 14 Dec 2005 08:11:07 -0800 (PST) Received: by 10.65.244.8 with HTTP; Wed, 14 Dec 2005 08:11:07 -0800 (PST) Message-ID: <84d933650512140811l5a8e79a7t@mail.gmail.com> Date: Wed, 14 Dec 2005 12:11:07 -0400 From: "Ing. Jhon Carrillo // Caracas, Venezuela" To: pgsql-admin@postgresql.org Subject: 0 % Data lost MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_26055_3434127.1134576667109" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.799 required=5 tests=[AWL=0.156, HTML_00_10=0.642, HTML_MESSAGE=0.001] X-Spam-Score: 0.799 X-Spam-Level: X-Archive-Number: 200512/126 X-Sequence-Number: 19846 ------=_Part_26055_3434127.1134576667109 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi all, I need to use PITR for to do backup in a critical enviroment, but this configuration save the segment files in the backup directory only when the segment file (in pg_xlog) is full, =BFIs there any way to configure the WAL like a real online backup? In my enviroment is necesary the 0% data lost, any idea?. regards, -- Jhon Carrillo IT Senior Engineer Caracas-Venezuela ------=_Part_26055_3434127.1134576667109 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi all,

I need to use PITR for to do backup in a critical enviroment= , but this configuration save the segment files in the backup directory onl= y when the segment file (in pg_xlog) is full, =BFIs there any way to config= ure the WAL like a real online backup?


In my enviroment is necesary the 0% data lost, any idea?.
regards,

--
Jhon Carrillo
IT Senior Engineer
Caracas-Ven= ezuela ------=_Part_26055_3434127.1134576667109--