X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B10DA9FA3CD for ; Tue, 20 Jun 2006 07:56:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 03423-10 for ; Tue, 20 Jun 2006 07:56:12 -0300 (ADT) X-Greylist: delayed 00:24:51.455404 by SQLgrey- Received: from mx01.bucher-handel.de (mx02.schinkel.de [82.140.26.112]) by postgresql.org (Postfix) with ESMTP id 139979FA219 for ; Tue, 20 Jun 2006 07:56:11 -0300 (ADT) Received: from 192.168.3.13 (server-sst-c1 [192.168.3.13]) by mx01.bucher-handel.de (Postfix) with ESMTP id 422D5340E9 for ; Tue, 20 Jun 2006 12:31:17 +0200 (CEST) To: pgsql-admin@postgresql.org From: Stefan.Schmidt@schinkel.de Subject: 2,2gb of pg_xlog ?? Date: 20 Jun 2006 10:31:17 UT X-Priority: 3 (Normal) Importance: normal X-Mailer: DvISE by Tobit Software, Germany (0224.43484C4746464A4D494E) X-David-Sym: 0 X-David-Flags: 0 Message-ID: <0000EA81.4497EA95@192.168.3.13> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_000_0000EA81.4497EA95" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/182 X-Sequence-Number: 22144 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_0000EA81.4497EA95 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7Bit Hi, I'm new to pgsql, so please be kind ;-) ok here my problem: I have a linux box with Debian Woody and pgsql 7.2. The problem is in the pg_xlog hold about 137 files with 16 MB each, the oldest file is from 2005. I read the WAL docu but as far as I'm understandig it, it should be auto cleand as long as isn't configured otherwise. But it is not, all options mentioned in the WAL doku are not set.. Any suggestions? here is my postgres.conf ------ fsync = off debug_level = 0 log_connections = off log_pid = on log_timestamp = on syslog = 1 # if syslog is 0, turn silent_mode off! silent_mode = off syslog_facility = LOCAL0 trace_notify = off max_connections = 64 # shared_buffers must be at least twice max_connections, and not less than 16 shared_buffers = 128 # TCP/IP access is allowed by default, but the default access given in # pg_hba.conf will permit it only from localhost, not other machines. tcpip_socket = on sort_mem = 512 ------ cu ------_=_NextPart_000_0000EA81.4497EA95 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi,
 
I'm new to pgsql, so please be kind ;-)
 
ok here my problem:
 
I have a linux box with Debian Woody and pgsql 7.2.
 
The problem is in the pg_xlog hold about 137 files with 16 MB each, the oldest file is from 2005.
 
I read the WAL docu but as far as I'm understandig it, it should be auto cleand as long as isn't configured otherwise.
But it is not, all options mentioned in the WAL doku are not set..
 
Any suggestions?
 
here is my postgres.conf
 
------

fsync =3D off
debug_level =3D 0
log_connections =3D off
log_pid =3D on
log_timestamp =3D on
syslog =3D 1
# if syslog is 0, turn silent_mode off!
silent_mode =3D off
syslog_facility =3D LOCAL0
trace_notify =3D off
max_connections =3D 64
# shared_buffers must be at least twice max_connections, and not less than 16
shared_buffers =3D 128
# TCP/IP access is allowed by default, but the default access given in
# pg_hba.conf will permit it only from localhost, not other machines.
tcpip_socket =3D on
sort_mem =3D 512
            
 
------
 
cu
 
------_=_NextPart_000_0000EA81.4497EA95--