Re: - Mailing list pgsql-general

From Kalai R
Subject Re:
Date
Msg-id CAGxuanOjUs6k75rMDjMTwZ8c4NGL8z+qBkk9Ax3yhExQ1AZErw@mail.gmail.com
Whole thread Raw
In response to Re:  (John R Pierce <pierce@hogranch.com>)
Responses Re:  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re:  (Krystian Bigaj <krystian.bigaj@gmail.com>)
List pgsql-general
 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.

I face  this problem in Windows XP and Windows 7 but not all windows XP and Windows 7.
In Windows 8 and Windows Server no problem.

It seems like Windows isn't waiting for the service to exit cleanly before its pulling the plug.

I think so, but I don't know how to solve this problem.


On Wed, Jul 23, 2014 at 12:20 PM, John R Pierce <pierce@hogranch.com> wrote:
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

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re:
Next
From: Rebecca Clarke
Date:
Subject: Index usage with slow query