pg_controldata: could not read file "/opt/postgres/9.2/data//global/pg_control": Success

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pg_controldata: could not read file "/opt/postgres/9.2/data//global/pg_control": Success
Date: 2018-10-08 05:39:43
Message-ID: CAEHH7R5QuYvR8c6ksD9c_+t12ps3FNRBQsy3mY9X=A1fQ6ONQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

*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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ROS Didier 2018-10-08 06:29:57 RE: Why the index is not used ?
Previous Message Paul McGarry 2018-10-07 22:10:30 Re: Why the index is not used ?