2,2gb of pg_xlog ??

From: Stefan(dot)Schmidt(at)schinkel(dot)de
To: pgsql-admin(at)postgresql(dot)org
Subject: 2,2gb of pg_xlog ??
Date: 2006-06-20 10:31:17
Message-ID: 0000EA81.4497EA95@192.168.3.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ow 2006-06-20 10:40:37 Unique constraint and index-combination feature in 8.1
Previous Message Oleg Golovanov 2006-06-20 07:29:42 DocBook 4.2 detecting at configure time