Can't start postgresql server

From: ChoonSoo Park <luispark(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Can't start postgresql server
Date: 2014-06-24 20:37:04
Message-ID: CACgbiFtE0vPEyts4oPznrbZdRcTyWgttAQ2EY1CS4sPSn4B9nw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Altec103 2014-06-24 20:37:23 Re: Error When Trying to Use Npgsql to COPY into a PostgreSQL Database
Previous Message Adrian Klaver 2014-06-24 20:30:45 Re: Error When Trying to Use Npgsql to COPY into a PostgreSQL Database