*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.kla...@aklaver.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.kla...@aklaver.com >