Warmest regards, Ericson Smith
Tracking Specialist/DBA
+-----------------------+---------------------------------+
| http://www.did-it.com | "When you have to shoot, shoot, |
| [EMAIL PROTECTED] | 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 [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
begin:vcard fn:Ericson Smith n:Smith;Ericson org:Did-it.com;Programming adr:#304;;55 Maple Avenue;Rockville Center;NY;11570;USA email;internet:[EMAIL PROTECTED] title:Web Developer tel;work:516-255-0500 tel;cell:646-483-3420 note:Nothing special! x-mozilla-html:FALSE url:http://www.did-it.com version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
