Re:
От | John R Pierce |
---|---|
Тема | Re: |
Дата | |
Msg-id | 53CF5B4F.8070208@hogranch.com обсуждение исходный текст |
Ответ на | Re: (Kalai R <softlinne.kv@gmail.com>) |
Ответы |
Re:
|
Список | pgsql-general |
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.
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 по дате отправления: