Thread: problem with ipc-daemon2 start as a service

problem with ipc-daemon2 start as a service

From
"jean-philippe jacoupy "
Date:
Hi,

I've build from sources postgresql 7.4.1 with the same ./configure command as described in this guide:

http://www.tishler.net/jason/software/postgresql/postgresql-7.4.1.README

This is what I get whenever I try to launch ipc-daemon2:

cray@lavieenrose ~
$ cygrunsrv -S ipc-daemon2
cygrunsrv: Error starting a service: QueryServiceStatus:  Win32 error 1062:

I have already tryed to do the chmod thing, changed nothing.
Also I don't have any logs in /var/log/

But if I don't use ipc-daemon2 as a service then when I run step 8 I get this:
<log>

        postgres@lavieenrose /usr/share/postgresql
        $ initdb -D ./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 ./data/... ok
        creating directory ./data//base... ok
        creating directory ./data//global... ok
        creating directory ./data//pg_xlog... ok
        creating directory ./data//pg_clog... ok
        selecting default max_connections... 10
        selecting default shared_buffers... 50
        creating configuration files... ok
        creating template1 database in ./data//base/1... FATAL:  could not create shared
         memory segment: Not enough core
        DETAIL:  Failed system call was shmget(key=1, size=1081344, 03600).
        HINT:  This error usually means that PostgreSQL's request for a shared memory se
        gment exceeded available memory or swap space. To reduce the request size (curre
        ntly 1081344 bytes), reduce PostgreSQL's shared_buffers parameter (currently 50)
         and/or its max_connections parameter (currently 10).
        The PostgreSQL documentation contains more information about shared memo
        ry configuration.

        initdb: failed
</log>

Running system:
Windows XP Pro SP 1

cygcheck:
cray@lavieenrose ~
$ cygcheck -c cygwin cygipc postgresql
Cygwin Package Information
Package              Version        Status
cygipc               2.02-1         OK
cygwin               1.5.6-1        OK

E-mail, Dialogue en direct et SMS gratuits sur minitel : 3615 CARAMAIL


Re: problem with ipc-daemon2 start as a service

From
"Leeuw van der, Tim"
Date:
Hi,

the IPC daemon should be started with the following commands:

ipc-daemon2.exe --install-as-service

net start "cygwin ipc daemon 2"

The first installs it as a service, the 2nd makes sure the service runs. So
unless you configure the service to start automatically, then after
installation you only need the 2nd command to run the IPC daemon. And if you
start the service automatically, you don't have to worry about it anymore at
all.

regards,


--Tim

THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you received
this in error, please contact the sender and delete the e-mail and its
attachments from all computers.



-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of jean-philippe
jacoupy
Sent: woensdag 21 januari 2004 16:36
To: pgsql-cygwin@postgresql.org
Subject: [CYGWIN] problem with ipc-daemon2 start as a service


Hi,

I've build from sources postgresql 7.4.1 with the same ./configure command
as described in this guide:

http://www.tishler.net/jason/software/postgresql/postgresql-7.4.1.README

This is what I get whenever I try to launch ipc-daemon2:

cray@lavieenrose ~
$ cygrunsrv -S ipc-daemon2
cygrunsrv: Error starting a service: QueryServiceStatus:  Win32 error 1062:

I have already tryed to do the chmod thing, changed nothing.
Also I don't have any logs in /var/log/

But if I don't use ipc-daemon2 as a service then when I run step 8 I get
this:
<log>

        postgres@lavieenrose /usr/share/postgresql
        $ initdb -D ./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 ./data/... ok
        creating directory ./data//base... ok
        creating directory ./data//global... ok
        creating directory ./data//pg_xlog... ok
        creating directory ./data//pg_clog... ok
        selecting default max_connections... 10
        selecting default shared_buffers... 50
        creating configuration files... ok
        creating template1 database in ./data//base/1... FATAL:  could not
create shared
         memory segment: Not enough core
        DETAIL:  Failed system call was shmget(key=1, size=1081344, 03600).
        HINT:  This error usually means that PostgreSQL's request for a
shared memory se
        gment exceeded available memory or swap space. To reduce the request
size (curre
        ntly 1081344 bytes), reduce PostgreSQL's shared_buffers parameter
(currently 50)
         and/or its max_connections parameter (currently 10).
        The PostgreSQL documentation contains more information about shared
memo
        ry configuration.

        initdb: failed
</log>

Running system:
Windows XP Pro SP 1

cygcheck:
cray@lavieenrose ~
$ cygcheck -c cygwin cygipc postgresql
Cygwin Package Information
Package              Version        Status
cygipc               2.02-1         OK
cygwin               1.5.6-1        OK

E-mail, Dialogue en direct et SMS gratuits sur minitel : 3615 CARAMAIL


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly

Re: problem with ipc-daemon2 start as a service

From
"jean-philippe jacoupy "
Date:
I manage to found
why it didn't work.
It cames from my
/etc/group and
/etc/passwd whitch
weren't good.

Now PostgreSQL work
as a service ^_^

------- Message
d'origine -------
>De:  Leeuw van der,
Tim
<tim.leeuwvander@nl.unisys.com>
>Date: Tue, 27 Jan
2004 02:34:31 -0500
>Sujet: Re: [CYGWIN]
problem with
ipc-daemon2 start as
a service

>Hi,

>the IPC daemon
should be started
with the following
commands:

>ipc-daemon2.exe
--install-as-service

>net start "cygwin
ipc daemon 2"

>The first installs
it as a service, the
2nd makes sure the
service runs. So
>unless you
configure the
service to start
automatically, then
after
>installation you
only need the 2nd
command to run the
IPC daemon. And if
you
>start the service
automatically, you
don't have to worry
about it anymore at
>all.

>regards,

--
GEEK CODE
Version: 3.1
GCSd+s+:+a--C++(++++)UBCSP+>+++L-E-W++N-o?K?wOM+V-PS+PE+Y+PGP+t+5?X+R++tvb++DID+Ge++hr++ ?


E-mail, Dialogue en direct et SMS gratuits sur minitel : 3615 CARAMAIL