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
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 ? |