pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql Database Corrupted
2+ messages / 2 participants
[nested] [flat]
* Postgresql Database Corrupted
@ 2007-10-30 16:20 karthik keyan <karthik_arnold1@yahoo.com>
2007-10-31 15:07 ` Re: Postgresql Database Corrupted Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: karthik keyan @ 2007-10-30 16:20 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgresql Database Corrupted
2007-10-30 16:20 Postgresql Database Corrupted karthik keyan <karthik_arnold1@yahoo.com>
@ 2007-10-31 15:07 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2007-10-31 15:07 UTC (permalink / raw)
To: karthik keyan <karthik_arnold1@yahoo.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-10-31 15:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-30 16:20 Postgresql Database Corrupted karthik keyan <karthik_arnold1@yahoo.com>
2007-10-31 15:07 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox