Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can't initdb under cygwin

Can't initdb under cygwin

From
Együd Csaba
Date:
Hi,
As I wrote in my previous letter, I would like to use postgres under
Windows. My first idea - compiling directly from the source package didn't
work. So I tied to use the binary package shipped with cygwin (postgres
7.3.2-1). It has been installed. But initdb sent the following error
message:
-------------------------------------
$ initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "Csaba".
This user must also own the server process.

The database cluster will be initialized with locale C.

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

initdb failed.
--------------------------------------------

During the compilation process the make complains about something similar:
'semget' and 'IpcSemaphoreCreate'. But I has found a reference in cygwin
documentation about something 'getsem'. Is taht possible that the binary
package doesn't support semaphores? I don't think so.

How could I make it work?

Thanks,
Csaba

Re: Can't initdb under cygwin

From
Tom Lane
Date:
=?iso-8859-1?Q?Egy=FCd_Csaba?= <csegyud@freemail.hu> writes:
> As I wrote in my previous letter, I would like to use postgres under
> Windows. My first idea - compiling directly from the source package didn't
> work. So I tied to use the binary package shipped with cygwin (postgres
> 7.3.2-1).

I think you are lacking cygipc.  That may explain the compile failure as
well.

            regards, tom lane

Re: Can't initdb under cygwin

From
Együd Csaba
Date:
Thank you Tom,
this was the problem. I already have managed to avoid this message.
I am setified with the result. It works in the same way as it does on
RedHat.

Best Regards,
--Csaba

> I think you are lacking cygipc.  That may explain the compile failure as
> well.
>
> regards, tom lane
>
>
>

Re: Can't initdb under cygwin

From
Erick Dennis
Date:
Install cygipc-1.13-2.tar.bz2 (look for it on google).

Best Regards.

On Sun, 11 May 2003, Együd Csaba wrote:

> Hi,
> As I wrote in my previous letter, I would like to use postgres under
> Windows. My first idea - compiling directly from the source package didn't
> work. So I tied to use the binary package shipped with cygwin (postgres
> 7.3.2-1). It has been installed. But initdb sent the following error
> message:
> -------------------------------------
> $ initdb -D /usr/local/pgsql/data
> The files belonging to this database system will be owned by user "Csaba".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> Fixing permissions on existing directory /usr/local/pgsql/data... ok
> creating directory /usr/local/pgsql/data/base... ok
> creating directory /usr/local/pgsql/data/global... ok
> creating directory /usr/local/pgsql/data/pg_xlog... ok
> creating directory /usr/local/pgsql/data/pg_clog... ok
> creating template1 database in /usr/local/pgsql/data/base/1...
> IpcSemaphoreCreate: semget(key=
> 1, num=17, 03600) failed: Function not implemented
>
> initdb failed.
> --------------------------------------------
>
> During the compilation process the make complains about something similar:
> 'semget' and 'IpcSemaphoreCreate'. But I has found a reference in cygwin
> documentation about something 'getsem'. Is taht possible that the binary
> package doesn't support semaphores? I don't think so.
>
> How could I make it work?
>
> Thanks,
> Csaba
>
>
> ---------------------------(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
>

--
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

mQGiBD3AVWoRBACodcxl03gUoJOqgzRfAheGLKeri8MdDy8F3fX/LwIihpWQMwh6
goSEhp6f+VkINDJ3cX3OgTYVAIJLBrzzka2wbDHnTv9A7j8+VB4Nh2ZY9RrcZdxX
g2z2NNdWVmxLPKTK+wbTXFsyLtj2IR0TASQdJKOL+VX6W7N/LYY2Mz4AXwCg8DC3
8cBi8P2ld48Un/Gvl1s/xHkD/j4r3WCsDGAzof2FiZ3wOkP9fgPbOk7v20FdXhOA
hjmGY7GCb0tsEPALPj2St3BKVgTH7iJ08us9lIx9Kux9XV1ZhlkZr1G3A0bkgUfk
Fcmih3FWmbV88Z4JFB1vhsrCFzgq3PHu5Wy37ObhpoVbs9ajo9vX09xZAL4SYq6o
7STAA/9UYgUwbB8fzG68Z7WLG8SDgEy5AL9ObHIUri+HeIHGSMtbjcksIMXkL1L5
CedPJDf/tphWrgvgROSWALJOvwc8cDAX/iwWyzAtmj+X8Xbx1QS0OJc8yPk4j9VI
Fp7zusVbRprBaIuk3ur29WbDCGFUpkyBTIdxjyw04P+sjcIxObQtRXJpY2sgRGVu
bmlzIChlRGVubmlzKSA8ZWRlbm5pc0Byb290c2hlbGwuYmU+iFcEExECABcFAj3A
VWoFCwcKAwQDFQMCAxYCAQIXgAAKCRBAR/8wlx6vQEk5AJ0fK5oMOR7Xhh6ZU4qB
Q4eFq6a/uQCcCgQ42duQ/0qgsmnu/aBcEi0EtHO5AQ0EPcBVbhAEAORKwkRPWpS5
qDe35p97UTcD2T2Oe2q29U2MV9Z5eDM5oPWYpXhGyIsKVUW2UyVpWfbVvLQfWVO+
ehfoDBHPI0GUZoOjjGBmwprII8hVc+YpJHnjTkB7ZoxNUlwCamuYXlNmQr6saQZO
sfCJO9og64+25/OGZXmd2oOC/C1qeYmTAAMFA/4xRwY6r5m03lZI1hdlR/9PzC01
ZD46bTrhIYFAeZZmyVbsttmz3A0/gMxj2sxaHoFnQE4QO3xqAV8k2KvxNzArEuj/
rpu6SaFTBG+u7ikkkCb1hCgukF6kKIAZKP9QSsTGFVgBaUlaT6PLm7LMHq2Mauap
OfztGsOfayzARNwu0IhGBBgRAgAGBQI9wFVuAAoJEEBH/zCXHq9A9FkAnjVE9wCa
i1Gau6ypIxomane6UD3NAKDkl1ulR3iEsdy8fF99Oo95tSkawg==
=86sd
-----END PGP PUBLIC KEY BLOCK-----

Cygwin - Postgres won't start

From
Együd Csaba
Date:
Hi,
I previously successfully installed postgres (7.3.2-1) under cygwin - thanks
for your help. I found it accelent. Really. Everything - at least those
functions I use - is working absoultly the same way as under Linux.

But I decided (unfortunatelly) to set up XFree86 - just for fun. By now I
can't start my postgres server. X is ok, but postgres is down.

What could be the reason of this problem. I start ipc-daemon and try to
start postgres. I would like to underline that it had been working before I
installed X.
----------------------------------------------------------------------------
----------
$ ipc-daemon.exe &
[1] 2324

$ pg_ctl start -D /usr/local/pgsql/data -m fast  &
[2] 3208
[1]   Done                    ipc-daemon.exe

$ postmaster successfully started
IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: Function
not implemented

[2]+  Done                    pg_ctl start -D /usr/local/pgsql/data -m fast
----------------------------------------------------------------------------
-----------


My original startup file looks like this:
----------------------------------------------------------------------------
-----------
ipc-daemon 2>&1 &
pg_ctl start -D /usr/local/pgsql/data -m fast  2>&1 &
----------------------------------------------------------------------------
-----------

I am looking forward to your answer. Thank you in advance.

-- Csaba