pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Erik Jones <erik@myemma.com>
To: General Postgresql List <pgsql-sql@postgresql.org>
Subject: Disk is full, what's cool to get rid of?
Date: Thu, 27 Jul 2006 11:20:59 -0500
Message-ID: <44C8E7EB.3040608@myemma.com> (raw)

Hello, quick question.  I've run into an issue with the disk that my 
development box is on filling up and preventing pretty much any writing 
(inserts, updates, deletes, etc...) from happening.  Other than some 
piddly text logs the db is pretty much the only thing on the box.  So, 
my question is:  what can I do to free space and run a full vacuum? (I 
was not the one who set up this box and there has been virtually no 
administration or maintenance on it that I know of...)  How about the 
WAL files in pg_xlog?  How critical are they when no data on the system 
is critical in and of itself?  Any suggestions would be greatly 
appreciated...

-- 
erik jones <erik@myemma.com>
software development
emma(r)




view thread (10+ messages)  latest in thread

Message-ID: <44C8E7EB.3040608@myemma.com>
Permalink:  ../44C8E7EB.3040608@myemma.com/
Also on:    postgresql.org/message-id/44C8E7EB.3040608@myemma.com

 · 

reply

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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: erik@myemma.com
  Subject: Re: Disk is full, what's cool to get rid of?
  In-Reply-To: <44C8E7EB.3040608@myemma.com>

* 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