| From: | Shoaib Mir <shoaibmir(at)gmail(dot)com> |
|---|---|
| To: | raghavendra t <raagavendra(dot)rao(at)gmail(dot)com> |
| Cc: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Server not Starting |
| Date: | 2010-04-14 06:44:05 |
| Message-ID: | j2mbf54be871004132344hba99879cv14988aa206a3064d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Apr 14, 2010 at 3:35 PM, raghavendra t <raagavendra(dot)rao(at)gmail(dot)com>wrote:
> Hi,
>
> Log file
> =====
>
> LOG: database system was interrupted; last known up at 2010-04-12 10:53:12
> IST
> LOG: database system was not properly shut down; automatic recovery in
> progress
> LOG: record with zero length at 0/1A0003C8
> LOG: redo is not required
> FATAL: could not access status of transaction 889
> DETAIL: Could not read from file "pg_clog/0000" at offset 0: Success.
> LOG: startup process (PID 303) exited with exit code 1
> LOG: aborting startup due to startup process failure
>
Try using pg_resetxlog to reset the control info on the DB cluster. Once you
have done that try re-starting and hopefully that should work then, but you
will I think lose everything from the last checkpoint by using pg_resetxlog.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | raghavendra t | 2010-04-14 07:00:00 | Re: Server not Starting |
| Previous Message | Craig Ringer | 2010-04-14 05:41:45 | Re: pl/java status |