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




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

On 10/30/07, karthik keyan <karthik_arnold1@yahoo.com> 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