Re: PSQL Server couldn't start

On 07/22/2014 09:01 PM, Kalai R wrote:
> Hi,
>
> I am facing a serious problem with postgresql frequently. I am using
> postgresql 9.3 in Windows OS with VisualStudio. we have more customers.
>
> We shutting down the system properly. But when we booting system,
> postgresql service  didn't start. This happens frequently after we install.
>
> log details when I trying to start the psql server
>
> *server starting*
> *LOG:  database system was interrupted while in recovery at 2014-07-22
> 18:31:34 IST*
> *HINT:  This probably means that some data is corrupted and you will
> have to use the last backup for recovery.*
> *LOG:  database system was not properly shut down; automatic recovery in
> progress*

Well the above would indicate it is not being shutdown properly.

How are you shutting it down?

What and how are you installing?

> *LOG:  redo starts at 0/1772908*
> *FATAL:  could not remove symbolic link "pg_tblspc/17681": Permission
> denied*

Permissions issue.

Who are you running the service as?

> *CONTEXT:  xlog redo create tablespace: 17681 "C:/GLOIER/gPRO/Data/GT"*
> *LOG:  startup process (PID 4992) exited with exit code 1*
> *LOG:  aborting startup due to startup process failure*
>
>
> Why this happens?
>
> Help me to solve this problem.
>
> Thank You.
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com