Thread

1. Problem mit PostgreSQL

   Michelle Konzack <linux.mailinglists@freenet.de> — 2002-09-25T16:47:26Z

   Hallo, 
   
   After seting up a new SQL-Server: 
   
   Debian-WOODY    (www.lehmanns.de)
   2.4.18          selfcompiled
   PostgreSQL      7.2.1-2
   php4-cgi        4:4.1.2-4
   php4-pear       4:4.1.2-4
   php4-pgsql      3:4.1.2-4
   phppgadmin      2.4.1-2
   python          2.1.3-3
   Apache          1.3.26-0woody1
   
   I have gotte many trouble:
   
   PostgreSQL do not let me create any databases: 
   
   tamay@sql:~/ > su postgres
   postgres@sql:/ > /usr/lib/postgresql/bin/initdb -D /home/postgresql/tamay
   The files belonging to this database system will be owned by user
   "postgres". 
   The user must also own the server process.
   
   creating directory /home/postgresql/tamay... ok
   creating directory /home/postgresql/tamay/base... ok
   creating directory /home/postgresql/tamay/global... ok
   creating directory /home/postgresql/tamay/pg_xlog... ok
   creating directory /home/postgresql/tamay/pg_clog... ok
   creating template1 database in /home/postgesql/tamay/base/1...
   IpcSeemaporeCreate: segment(key=1, num=17,03600) failed: function not
   implemented
   
   initdb failed.
   Removing /home/postgresql/tamay.
   
   Now I have installed the sources postgresql-7.1.3.tar.gz from the 
   O'Reilly (Practical PostgeSQL), Something for Debian modified (e.g. 
   Directorys), compiles, installed and started. 
   
   All Examples of the Book are working...
   
   Oh yes, anyone has told me, that the Semaphores are not enabled in 
   the Kernel, but I have only found SEMMNS and SEMMNI and changed 
   them to a higher value, but where can I enable Semaphores ??? 
   There is no option in 'make config' or 'make menuconfig'.
   
   Question:   Is in the Debian-Package a BUG or is something missing ?
   
   
   Many Thanks in Advance
   Michelle
   
   
   

2. Re: Problem mit PostgreSQL

   Doug McNaught <doug@wireboard.com> — 2002-09-29T16:38:59Z

   Michelle Konzack <linux.mailinglists@freenet.de> writes:
   
   > Hallo, 
   > 
   > After seting up a new SQL-Server: 
   > 
   > Debian-WOODY    (www.lehmanns.de)
   > 2.4.18          selfcompiled
                     ^^^^^^^^^^^^
   
   > creating template1 database in /home/postgesql/tamay/base/1...
   > IpcSeemaporeCreate: segment(key=1, num=17,03600) failed: function not
   > implemented
   
   I'm guessing you forgot to turn on SysV IPC when you configured the
   kernel.  Check your .config file.
   
   -Doug
   
   

3. Re: Problem mit PostgreSQL

   Justin Clift <justin@postgresql.org> — 2002-09-29T16:40:36Z

   Hi Michelle,
   
   Michelle Konzack wrote:
   <snip>
   > creating template1 database in /home/postgesql/tamay/base/1...
   > IpcSeemaporeCreate: segment(key=1, num=17,03600) failed: function not
   > implemented
   <snip>
   
   Not sure about this, but it looks like your kernel has been compiled
   without support for IPC.
   
   Is that possible?
   
   :-)
   
   Regards and best wishes,
   
   Justin Clift
   
   <snip>
   > Many Thanks in Advance
   > Michelle
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 4: Don't 'kill -9' the postmaster
   
   -- 
   "My grandfather once told me that there are two kinds of people: those
   who work and those who take the credit. He told me to try to be in the
   first group; there was less competition there."
      - Indira Gandhi