Обсуждение: Can't initdb under cygwin
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
=?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
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 > > >
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-----
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