Hi Raghvendra, Free up some space before restarting. Old archive/backup/logs could be the candidate for clean up. You do not need much space to restart instance. Once started, login to db and execute checkpoint.
Thanks Rajni On Mon, 8 Oct 2018 at 4:40 pm Raghavendra Rao J S V < raghavendra...@gmail.com> wrote: > *Hi All,* > > *archive_mode *is turned *on *unfortunately in my Postgres 9.2 database. > > Due to that disk space is full 100%. We are facing below problem when we > try to start the database. > > *PANIC: could not read from control file:Success* > > Please help me how to handle this situation. > > > > *Log files contians the infomration as below:-* > > 2018-10-08 05:27:44.262 UTC,,,27688,,5bbaead0.6c28,1,,2018-10-08 05:27:44 > UTC,,0,LOG,00000,"database system was interrupted while in recovery at > 2018-10-03 15:01:03 UTC",,"This probably means that some data is corrupted > and you will have to use the last backup for recovery.",,,,,,,"" > 2018-10-08 05:27:44.262 UTC,,,27688,,5bbaead0.6c28,2,,2018-10-08 05:27:44 > UTC,,0,LOG,00000,"database system was not properly shut down; automatic > recovery in progress",,,,,,,,,"" > 2018-10-08 05:27:44.265 UTC,,,27688,,5bbaead0.6c28,3,,2018-10-08 05:27:44 > UTC,,0,LOG,00000,"redo starts at 93/775816B0",,,,,,,,,"" > 2018-10-08 05:27:44.514 UTC,,,27688,,5bbaead0.6c28,4,,2018-10-08 05:27:44 > UTC,,0,FATAL,53100,"could not extend file ""base/77017/160045"": wrote only > 4096 of 8192 bytes at block 278",,"Check free disk space.",,,"xlog redo > insert(init): rel 1663/77017/160045; tid 278/1",,,,"" > 2018-10-08 05:27:44.517 UTC,,,27686,,5bbaead0.6c26,1,,2018-10-08 05:27:44 > UTC,,0,LOG,00000,"startup process (PID 27688) exited with exit code > 1",,,,,,,,,"" > 2018-10-08 05:27:44.517 UTC,,,27686,,5bbaead0.6c26,2,,2018-10-08 05:27:44 > UTC,,0,LOG,00000,"aborting startup due to startup process > failure",,,,,,,,,"" > > -- > Regards, > Raghavendra Rao J S V > Mobile- 8861161425 > -- Thanks Regards, Rajni 0410472086
