Re: Out of space - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Out of space
Date
Msg-id 200404071919.46503.peter_e@gmx.net
Whole thread Raw
In response to Out of space  ("Tom Bakken" <tom.bakken@tx.usda.gov>)
Responses Re: Out of space
List pgsql-admin
Tom Bakken wrote:
> I've been running a postgres for 2 or 3 years without a problem.
> This morning my disk space for the database filled up.  I need to
> know what transaction/log files I can truncate or delete without
> compromising the system.  These files are located under
> /var/lib/pgsql/data/

The answer is normally "none" unless you have experienced crashes or
other problems that might have left stale files lying around.  But you
say have had no problem ...

If you have any suspicion in that direction, please show us the exact
files you're thinking about.  A note about which PG version you are
running would also help.


pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: installation problem
Next
From: Tom Lane
Date:
Subject: Re: Out of space