Re:

John R Pierce <pierce@xxxxxxxxxxxx> · Tue, 22 Jul 2014 23:50:55 -0700



    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