pg_ctl - PostgreSQL server has stopped working

[Vance Karimi]

Downloaded the latest version of Datafari 64bit for windows dated 5/3/2015.

Installed it on an Amazon AWS Windows 2012 R2 64bit AMI server instance.

Noticed an issue when running start-datafari.bat and it seemed related to folder permission issues.

When I run the following command (from start-datafari.bat) from c:\Datafari

.\pgsql\bin\pg_ctl.exe -D .\pgsql\data -l .\logs\pgsql.log start

I get the following error:

pg_ctl - starts/stops/restarts the PostgreSQL server has stopped working

Problem signature:

  Problem Event Name: APPCRASH

  Application Name: pg_ctl.exe

  Application Version: 9.3.3.14048

  Application Timestamp: 5302fc77

  Fault Module Name: MSVCR100.dll

  Fault Module Version: 6.3.9600.17630

  Fault Module Timestamp: 54b0d74f

  Exception Code: c0000135

  Exception Offset: 0009e0b2

  OS Version: 6.3.9600.2.0.0.272.7

  Locale ID: 1033

  Additional Information 1: 1abe

  Additional Information 2: 1abee00edb3fc1158f9ad6f44f0f6be8

  Additional Information 3: 1abe

  Additional Information 4: 1abee00edb3fc1158f9ad6f44f0f6be8

On a Windows 7 64bit desktop I received a slightly different response:

PS C:\Datafari> .\pgsql\bin\pg_ctl.exe -D .\pgsql\data -l .\logs\pgsql.log start

server starting

PS C:\Datafari> Access is denied.

To get PostgreSQL to start, I had to uncheck 'Include inheritable permissions from this object's parent' from the advanced security settings for the c:\Datafari folder.

Then gave all groups & users modify/write access to the c:\Datafari\logs folder.

Once done, pg_ctl starts fine and the c:\Datafari\logs\pgsql.log is created.

Any thoughts?

[cedric...@francelabs.com]

Hi Vance,

considering how old this question is (Datafari 1.0 already !), can we consider your question as deprecated ? Such errors should not appear any more in the recent versions of Datafari.

Regards,

Cedric