Re: Out of space

From: Ericson Smith <eric(at)did-it(dot)com>
To: Tom Bakken <tom(dot)bakken(at)tx(dot)usda(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Out of space
Date: 2004-04-08 13:27:37
Message-ID: 40755349.8060209@did-it.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Why not just get a bigger disk?

Warmest regards,
Ericson Smith
Tracking Specialist/DBA
+-----------------------+---------------------------------+
| http://www.did-it.com | "When you have to shoot, shoot, |
| eric(at)did-it(dot)com | don't talk! - Tuco |
| 516-255-0500 | |
+-----------------------+---------------------------------+

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/
>
>Many of them have dates of more than a year ago. I'm kind of rusty with
>this. Postgres works too well to keep me fluent with troubleshooting.
>
>Tom Bakken
>Information Resource Manager
>Texas USDA, Rural Development
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>

Attachment Content-Type Size
eric.vcf text/x-vcard 315 bytes

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nicolas Kowalski 2004-04-08 13:33:24 Re: Database storage bloat
Previous Message Tom Bakken 2004-04-08 13:10:25 Re: Out of space