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 B7A059DC9F9 for ; Sun, 12 Feb 2006 06:47:43 -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 71875-05 for ; Sun, 12 Feb 2006 06:47:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from guri.is.scarlet.be (guri.is.scarlet.be [193.74.71.22]) by postgresql.org (Postfix) with ESMTP id 0CFE29DC82F for ; Sun, 12 Feb 2006 06:47:40 -0400 (AST) Received: from (ip-213-49-180-175.dsl.scarlet.be [213.49.180.175]) by guri.is.scarlet.be with ESMTP id k1CAlHZ18087 for ; Sun, 12 Feb 2006 11:47:28 +0100 From: postgres@pivert.org To: pgsql-admin@postgresql.org Subject: Switch log (WAL) Date: Sun, 12 Feb 2006 11:47:11 +0100 User-Agent: KMail/1.9 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200602121147.11349.postgres@pivert.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.55 required=5 tests=[NO_REAL_NAME=0.55] X-Spam-Score: 0.55 X-Spam-Level: X-Archive-Number: 200602/152 X-Sequence-Number: 20573 Hello, I'm new to the list, and I'm intereted in PostgreSQL replication (using WAL) As I didn't find any script to do that, I make mine, that seems to work. However, I wonder how can I "switch WAL logs", in order to have the standby database not too much late. The database actually generates few logs, and I would like one WAL to be generated once per hour. How Can I do that ? Regards,