From: | raghavendra t <raagavendra(dot)rao(at)gmail(dot)com> |
---|---|
To: | Shoaib Mir <shoaibmir(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 07:00:00 |
Message-ID: | x2hbc7de5a31004140000yedbcd06asef5c3acb33815a62@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Shoaib,
Tried with pg_resetxlog
[postgres(at)dbarhel564 bin]$ pg_resetxlog /usr/local/pgsql/mypg/
The database server was not shut down cleanly.
Resetting the transaction log might cause data to be lost.
If you want to proceed anyway, use -f to force reset.
[postgres(at)dbarhel564 bin]$ pg_resetxlog -f /usr/local/pgsql/mypg/
Transaction log reset
[postgres(at)dbarhel564 bin]$ pg_ctl start
server starting
[postgres(at)dbarhel564 bin]$ LOG: database system was shut down at 2010-04-12
12:26:15 IST
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 1335) exited with exit code 1
LOG: aborting startup due to startup process failure
[postgres(at)dbarhel564 bin]$
Regards
Raghavendra
On Wed, Apr 14, 2010 at 12:14 PM, Shoaib Mir <shoaibmir(at)gmail(dot)com> wrote:
> 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 | Shoaib Mir | 2010-04-14 07:09:44 | Re: Server not Starting |
Previous Message | Shoaib Mir | 2010-04-14 06:44:05 | Re: Server not Starting |