Re: PSQL Server couldn't start

*Well the above would indicate it is not being shutdown properly.How are
you shutting it down?*

PSQL server starterd as stoped by postgresql windows service. So when I
shutdown the machine postgres shutting down by postgres windows service

*What and how are you installing?*

Using windows binary zip file, I extract zip file and create cluster using
intidb then register windows service using pg_ctl

*Who are you running the service as?*

I try to start the psql server from command prompt using pg_ctl.exe

On Wed, Jul 23, 2014 at 9:47 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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(dot)klaver(at)aklaver(dot)com
>