Search Postgresql Archives

Can't start postgresql server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

From the pg_log folder, I can locate the following errors:

LOG:  database system was interrupted while in recovery at log time 2014-06-06 22:35:38 UTC
HINT:  If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.
LOG:  could not open tablespace directory "pg_tblspc/30022/PG_9.1_201105231": No such file or directory
LOG:  could not open tablespace directory "pg_tblspc/30023/PG_9.1_201105231": No such file or directory
LOG:  entering standby mode
LOG:  redo starts at 3/AD000020
FATAL:  online backup was canceled, recovery cannot continue
CONTEXT:  xlog redo checkpoint: redo 3/AD044D38; tli 26; xid 0/156687; oid 249448; multi 9; offset 17; oldest xid 1791 in DB 1; oldest running xid 0; shutdown
LOG:  startup process (PID 22536) exited with exit code 1
LOG:  terminating any other active server processes
LOG:  database system was interrupted while in recovery at log time 2014-06-06 22:35:38 UTC
HINT:  If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.
LOG:  could not open tablespace directory "pg_tblspc/30022/PG_9.1_201105231": No such file or directory
LOG:  could not open tablespace directory "pg_tblspc/30023/PG_9.1_201105231": No such file or directory
LOG:  entering standby mode
LOG:  redo starts at 3/AD000020
FATAL:  online backup was canceled, recovery cannot continue

Same errors repeat.

30022 & 30023 are symbolic links under data/pg_tblspc folder. Their target directories are lost somehow. Does it cause this problem? I tried to delete those 2 symbolic links but postgresql still can't start up.

Just wonder what is causing the postgresql to throw an error.

>> HINT:  If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.

Where can I specify recovery target? 

Thank you,
Choon Park

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux