Re:

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re:
Date: 2014-07-23 06:50:55
Message-ID: 53CF5B4F.8070208@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On 7/22/2014 11:42 PM, Kalai R wrote:
> *why not use the installer, which sets it all up correctly for you?*
> *
> *
> In previous, I use installer. but I face more data corruption problem
> and also server starting problem when shutting down the system. so I
> try to install my self.
>
>
> *I think the problem is, you ran initdb as your user account, but the
> system service is running as the special system accounbt
> NETWORK_SERVICE, or similar, and there may be files in the data
> directory which the NETWORK_SERVICE account doesn't have write access
> writes to. you can probably fix this with the cacls command.*
> *
> *
> I think you are correct. But I want to know why database corrupted
> even though I shutting down the machine properly. This is frequently
> happen when I use installer also.
>

It seems like Windows isn't waiting for the service to exit cleanly
before its pulling the plug. Is this a Windows *server* version, or is
it one of the newer desktop OS's like Windows 8? Windows 8 seems to
shut down rather fast, its quite possible its not bothering to wait for
services to exit.

this error...
*FATAL: could not remove symbolic link "pg_tblspc/17681": Permission
denied*
*CONTEXT: xlog redo create tablespace: 17681 "C:/GLOIER/gPRO/Data/GT"
*
suggests you're using a postgres tablespace ? I've not used tablespaces
much or at all in Windows, I don't know how well they work.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

  • Re: at 2014-07-23 06:42:37 from Kalai R

Responses

  • Re: at 2014-07-23 06:59:53 from Kalai R

Browse pgsql-general by date

  From Date Subject
Next Message Kalai R 2014-07-23 06:59:53 Re:
Previous Message Kalai R 2014-07-23 06:42:37 Re:

Browse pgsql-hackers by date

  From Date Subject
Next Message furuyao 2014-07-23 06:55:26 Re: timeout of pg_receivexlog --status-interval
Previous Message Kalai R 2014-07-23 06:42:37 Re: