Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_controldata: could not read file "/opt/postgres/9.2/data//global/pg_control":Success - Mailing list pgsql-general

From Rajni Baliyan
Subject Re: pg_controldata: could not read file "/opt/postgres/9.2/data//global/pg_control":Success
Date
Msg-id CAG5RORNMVSJqU0=3Je9mbow=yxzF8oRiJrJ64-8MhupvjGBnnA@mail.gmail.com
Whole thread Raw
In response to pg_controldata: could not read file "/opt/postgres/9.2/data//global/pg_control":Success  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
List pgsql-general
Tree view
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 <raghavendrajsv@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

pgsql-general by date:

Previous
From: Raghavendra Rao J S V
Date:
Subject: pg_controldata: could not read file "/opt/postgres/9.2/data//global/pg_control":Success
Next
From: magodo
Date:
Subject: pg9.6: no backup history file (*.backup) created on hot standby