Yo,
The postmaster service is configure to be logged-on as .\postgres user (same
username / password / privileges as the telnet user).
The *really* weird thing is that the service can select/insert/delete
rows/table in existing databases. The only failure is
for the CREATE DATABASE. This is what is the most confusing for me.
It might well be an environment issue, but same user would get the same
environment. So what could be next ?
Thanks
JM
----- Original Message -----
From: "S. L." <s0lao@netscape.net>
To: ""Jean-Marc Paulin"" <jmp@micromuse.com>; <pgsql-cygwin@postgresql.org>
Sent: Monday, June 24, 2002 6:37 AM
Subject: RE: [CYGWIN] ERROR: CREATE DATABASE: could not initialize database
directory
> [...]
> >If I run postmaster as a daemon from a cygwin telnet session, createdb
works
> >fine.
> >If I run postmaster as a service (via the cygrunsrv), createdb return the
> >error: "could not initialize database directory".
> [...]
>
> This means the user you login to the telnet session is different from the
user that executes postmaster as a service (usually SYSTEM or LocalSystem,
which, usually again :), is not provided with the rights to login), and/or
the options used to start the postmaster as a daemon are different from
those used to start it as a service.
>
> [...]
> >Any hints ?
> >
> [...]
>
> You must check the user context for the two cases, and make sure that you
use the same command line options for postmaster when started as a service,
also the environment variables.
>
> SLao
>
>
> __________________________________________________________________
> Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.com/
>
> Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/
>