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@did-it.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>