Re: Can't start postmaster

From: "Reshat Sabiq" <sabiq(at)purdue(dot)edu>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: Can't start postmaster
Date: 2002-12-22 01:28:52
Message-ID: 000001c2a959$7ff03f70$7480d380@main
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

I tried to switch to user postgres and initdb from that account as is
recommended in postgres-version.README. But I'm getting the error below
while trying that. Thank you in advance for any suggestions.

r.

P.S.
postgres(at)MAIN ~
$ initdb -D /usr/share/postgresql/data
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

Fixing permissions on existing directory /usr/share/postgresql/data...
ok
creating directory /usr/share/postgresql/data/base... ok
creating directory /usr/share/postgresql/data/global... ok
creating directory /usr/share/postgresql/data/pg_xlog... ok
creating directory /usr/share/postgresql/data/pg_clog... ok
creating template1 database in /usr/share/postgresql/data/base/1...
IpcSemaphore
Create: semget(key=1, num=17, 03600) failed: Function not implemented

initdb failed.

postgres(at)MAIN ~
$ net start postmaster
The postmaster service is starting.
The postmaster service could not be started.

The service did not report an error.

More help is available by typing NET HELPMSG 3534.



-----Original Message-----
From: pgsql-cygwin-owner(at)postgresql(dot)org
[mailto:pgsql-cygwin-owner(at)postgresql(dot)org] On Behalf Of Reshat Sabiq
Sent: Saturday, December 21, 2002 6:31 PM
To: pgsql-cygwin(at)postgresql(dot)org
Subject: [CYGWIN] Can't start postmaster

I'd appreciate any insight on the problems that you might see in console
printout below. I installed the postmaster service as owned by user
postgres:
cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D
/usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user
postgres --shutdown

I'm guessing that I might not be able to run it that way, because there
is no "su" command in cygwin/Windows.
Should I start from scratch and install the postmaster as owned by me?

On the flipside, how can I get me to own the server process? Is it like
putting me and postgres into a group?

Thanks,
r.

----------------------------------
me(at)MAIN ~
$ initdb -D /usr/share/postgresql/data
The files belonging to this database system will be owned by user "me"
.
This user must also own the server process.

The database cluster will be initialized with locale C.

Fixing permissions on existing directory /usr/share/postgresql/data...
ok
creating template1 database in /usr/share/postgresql/data/base/1...
FATAL: Can'
t create lock file /usr/share/postgresql/data/postmaster.pid: Permission
denied

initdb failed.

me(at)MAIN ~
$ net start postmaster
The postmaster service is starting.
The postmaster service could not be started.

The service did not report an error.

More help is available by typing NET HELPMSG 3534.

me(at)MAIN ~
$

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Cornelia Boenigk 2002-12-22 01:49:43 Re: Can't start postmaster
Previous Message Reshat Sabiq 2002-12-21 23:30:57 Can't start postmaster