From: Stefan.Schmidt@schinkel.de
To: pgsql-admin@postgresql.org
Subject: 2,2gb of pg_xlog ??
Date: 20 Jun 2006 10:31:17 UT
Message-ID: <0000EA81.4497EA95@192.168.3.13> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: Stefan.Schmidt@schinkel.de
Subject: Re: 2,2gb of pg_xlog ??
In-Reply-To: <0000EA81.4497EA95@192.168.3.13>
References: <0000EA81.4497EA95@192.168.3.13>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox