Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id DCEA11337B6B for ; Tue, 28 Sep 2010 07:01:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 63835-06 for ; Tue, 28 Sep 2010 10:01:19 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id 1B0F21337B69 for ; Tue, 28 Sep 2010 07:01:16 -0300 (ADT) Received: by iwn5 with SMTP id 5so5763894iwn.19 for ; Tue, 28 Sep 2010 03:01:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=Ig77Kra6r9H7RhbfWRWMQ6vxq0dzyWvRnD5C43Z4sYU=; b=EWEkiOS4gT5vws3GqBV3uPatQoGrPcUgp6llxtQPHB0bCQtdOpK8s3A2GuJuEfctQ9 NQKqQ8y4Scn5el6/2jgRWjNjC3BR+zHxrHQx3ZIq8T5o/CzUNzl/OqT08NCXHw0+k9iL l7blUSZbUd11HKMDaEXiQsB05sRjI91hnui+Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=JQj1Bey8u3HqO59tG67QoBdsu5CYp0rjTMvwbGdi6X57SG24MtRMjwQnbZf3jIklQK Rv03inROXZ5sDRWi7BPubMc0xsrPxCOpWucM24+59am8FVW/TykSwcOPGoGnRwjFmQQ7 ng1cstBZolORYYqgJ8c4C10IrfiydOmXEHZek= MIME-Version: 1.0 Received: by 10.231.40.3 with SMTP id i3mr802720ibe.66.1285668076462; Tue, 28 Sep 2010 03:01:16 -0700 (PDT) Received: by 10.231.191.18 with HTTP; Tue, 28 Sep 2010 03:01:13 -0700 (PDT) Date: Tue, 28 Sep 2010 15:31:13 +0530 Message-ID: Subject: Clean up of archived Xlogs in postgres-9. From: Nimesh Satam To: pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=000325574926ff238f04914eeced X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201009/193 X-Sequence-Number: 40396 --000325574926ff238f04914eeced Content-Type: text/plain; charset=ISO-8859-1 Hi, Can any one of you suggest how the archived Xlogs can be cleaned in postgres-9. We want to use streaming replication and have set the "wal_level" to "hot_standby" and "archive_mode" to "on". Regards, Nimesh. --000325574926ff238f04914eeced Content-Type: text/html; charset=ISO-8859-1 Hi,

Can any one of you suggest how the archived Xlogs can be cleaned in postgres-9.

We want to use streaming replication and have set the "wal_level" to "hot_standby" and "archive_mode" to "on".

Regards,
Nimesh.
--000325574926ff238f04914eeced--