X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5CD96D1D132 for ; Thu, 19 Feb 2004 17:07:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 41946-01 for ; Thu, 19 Feb 2004 13:07:19 -0400 (AST) Received: from imo-d07.mx.aol.com (imo-d07.mx.aol.com [205.188.157.39]) by svr1.postgresql.org (Postfix) with ESMTP id B91BAD1B52F for ; Thu, 19 Feb 2004 13:07:13 -0400 (AST) Received: from imo-d01.mx.aol.com (imo-d01.mx.aol.com [205.188.157.33]) by imo-d07.mx.aol.com (v93.12) with ESMTP id RELAYIN1-24034ed30260; Thu, 19 Feb 2004 12:06:56 -0500 Received: from Eeeggg499@netscape.net by imo-d01.mx.aol.com (mail_out_v36_r4.14.) id k.2.c2e49b2 (16239) for ; Thu, 19 Feb 2004 12:06:46 -0500 (EST) Received: from netscape.net (host191.200-82-26.telecom.net.ar [200.82.26.191]) by air-in03.mx.aol.com (v98.6) with ESMTP id MAILININ33-3f6f4034ed233c2; Thu, 19 Feb 2004 12:06:45 -0500 Message-ID: <4034EE99.9090105@netscape.net> Date: Thu, 19 Feb 2004 14:12:57 -0300 From: Eduardo Leva User-Agent: Mozilla/5.0 (X11; U; Linux i586; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: WAL logs and segment files Content-Type: multipart/alternative; boundary="------------050707000800000204000608" X-AOL-IP: 200.82.26.191 X-Mailer: Unknown (No Version) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/304 X-Sequence-Number: 12478 --------------050707000800000204000608 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Hi, guys... I'm reading the version 7.3.4 documentation and I found this: " "WAL logs are stored in the directory $PGDATA/pg_xlog, as a set of segment files, each 16 MB in size. Each segment is divided into 8 kB pages. The log record headers are described in access/xlog.h; record content is dependent on the type of event that is being logged. Segment files are given ever-increasing numbers as names, starting at 0000000000000000. The numbers do not wrap, at present, but it should take a very long time to exhaust the available stock of numbers. " in item 12.2 Implementation. The question is: How do I solve this situation, the remarked situation? The answer is not in the docs. Thanks. Pd. Sorry about my poor english. I speak spanish every day of my 3rd. world's life... Sigan adelante... Saludos. Eduardo Leva Programador Santa Fe Argentina. --------------050707000800000204000608 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, guys... I'm reading the version 7.3.4 documentation and I found this: "
"WAL logs are stored in the directory $PGDATA/pg_xlog, as a set of segment
 files, each 16 MB in size. Each segment is divided into 8 kB pages. The
 log record headers are described in access/xlog.h; record content is
 dependent on the type of event that is being logged. Segment files are
 given ever-increasing numbers as names, starting at 0000000000000000. The
 numbers do not wrap, at present, but it should take a very long time to
 exhaust the available stock of numbers. "
in item 12.2 Implementation. The question is: How do I solve this situation, the remarked situation? The answer is not in the docs. Thanks.

Pd. Sorry about my poor english. I speak spanish every day of my 3rd. world's life...
Sigan adelante... Saludos.

Eduardo Leva
Programador
Santa Fe Argentina.
--------------050707000800000204000608--