On 10/30/07, karthik keyan <[EMAIL PROTECTED]> wrote: > Hi admins > > I have a issue with my database . > > Its not starting up after /var got filled up > > After clearing some space still the database doesnt start up .. > > Pls find the log vacuumdb: vacuuming of database "insight_v1_0" failed: > ERROR: could not access status of transaction 124321809 > DETAIL: could not read from file > "/var/lib/pgsql/data/pg_clog/0076" at offset 147456: > Success
So, how did you clear some space? Did that involve deleting the file listed above? If not, you might be able to recreate the pg_clog/0076 file as a file filled with zeroes to get it back up, but who knows what data you might be missing. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
