cannot initdb

----- Original Message -----
From: "Joseph Koenig" <joe@jwebmedia.com>

IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function not

implemented

initdb failed.
Removing /usr/local/pgsql/data.
Removing temp file /tmp/initdb.16303.

What does the IpcSemaphoreCreate line mean? Thanks,

have u checked section 3.4 of the FAQ? -
http://www3.ca.postgresql.org/docs/faq-english.html#3.4

hth,

Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "

Joseph Koenig <joe@jwebmedia.com> writes:

IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function
not implemented

This would seem to indicate that SYSV IPC isn't turned on in your
kernel configuration.

-Doug
--
Doug McNaught Wireboard Industries http://www.wireboard.com/

Custom software development, systems and network consulting.
Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...

I don't see a SYSV IPC anywhere in the LINT file or the GENERIC. I
looked at:

http://www3.ca.postgresql.org/users-lounge/docs/7.1/admin/kernel-resources.html

and recompiled my kernel accordingly. This is in a jail, does that
affect things? I rebuild the kernel for the jail and restarted the jail
- received the same error. Any ideas? Should I try installing from the
source, or are the ports the best way to go? BTW, this machine has 1GB
of RAM and is a 1GHz processor if that helps at all. Thanks,

Joe

Doug McNaught wrote:

Joseph Koenig <joe@jwebmedia.com> writes:

I don't see a SYSV IPC anywhere in the LINT file or the GENERIC. I
looked at:

http://www3.ca.postgresql.org/users-lounge/docs/7.1/admin/kernel-resources.html

and recompiled my kernel accordingly. This is in a jail, does that
affect things? I rebuild the kernel for the jail and restarted the jail
- received the same error. Any ideas? Should I try installing from the
source, or are the ports the best way to go? BTW, this machine has 1GB
of RAM and is a 1GHz processor if that helps at all. Thanks,

I wish I knew enought about FreeBSD to help you--I'm more of a Linux
guy. It certainly sounds like it might have something to do with the
jail, but I don't know any details of how that system works.

Perhaps one of the FreeBSD lists might be of help...

-Doug
--
Doug McNaught Wireboard Industries http://www.wireboard.com/

Custom software development, systems and network consulting.
Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...

1)
is Firebird/Interbase SQL Server installed and running already ?
If it is ; I remember something wrong with semaphores between PostgreSQL and
Firebird.
In this situation you can get semaphores clean with some commands that I
couldnt remember now...

2)
you must stop any running postmaster process before initdb
----------------------------------------------------------------------------
-----------

Greetings,

Serkan Bektas

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Joseph Koenig
Sent: 12 Mart 2002 Sali 16:18
To: pgsql-general@postgresql.org
Subject: [GENERAL] cannot initdb

I installed 7.1.3 from ports on FreeBSD 4.2 and when I tried to initdb,
it failed:

su -l pgsql -c initdb
This database system will be initialized with username "pgsql".
This user will own all the data files and must also own the server process.

Creating directory /usr/local/pgsql/data
Creating directory /usr/local/pgsql/data/base
Creating directory /usr/local/pgsql/data/global
Creating directory /usr/local/pgsql/data/pg_xlog
Creating template1 database in /usr/local/pgsql/data/base/1
IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function not
implemented

initdb failed.
Removing /usr/local/pgsql/data.
Removing temp file /tmp/initdb.16303.

What does the IpcSemaphoreCreate line mean? Thanks,

Joe

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

You can see active semaphores ;
ipcs -s

and you can remove semaphores ;
ipcrm - s <sem ID>

karincaint# ipcs -s
Semaphores:
T ID KEY MODE OWNER GROUP
s 1114112 5432001 --rw------- pgsql pgsql
s 1114113 5432002 --rw------- pgsql pgsql
s 655362 5432003 --rw------- pgsql pgsql

karincaint# ipcrm -s 1114112

You must remove all active semaphores before initdb
I hope this helps.

Serkan Bektas

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Joseph Koenig
Sent: 12 Mart 2002 Sali 16:18
To: pgsql-general@postgresql.org
Subject: [GENERAL] cannot initdb

I installed 7.1.3 from ports on FreeBSD 4.2 and when I tried to initdb,
it failed:

su -l pgsql -c initdb
This database system will be initialized with username "pgsql".
This user will own all the data files and must also own the server process.

Creating directory /usr/local/pgsql/data
Creating directory /usr/local/pgsql/data/base
Creating directory /usr/local/pgsql/data/global
Creating directory /usr/local/pgsql/data/pg_xlog
Creating template1 database in /usr/local/pgsql/data/base/1
IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function not
implemented

initdb failed.
Removing /usr/local/pgsql/data.
Removing temp file /tmp/initdb.16303.

What does the IpcSemaphoreCreate line mean? Thanks,

Joe

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Joseph Koenig <joe@jwebmedia.com> writes:

Someone please tell me they have experience with PostgreSQL inside a
FreeBSD jail. I desperately need to get PostgreSQL up and running and
this is the one roadblock. Someone please help. This is what I get in
the jail:

%ipcs -s
ipcs: short read
SVID semaphores facility not configured in the system

Definitely sounds like something for the FreeBSD lists. Might be a
bug in the jail system from what you've said above. Good luck...

-Doug
--
Doug McNaught Wireboard Industries http://www.wireboard.com/

Custom software development, systems and network consulting.
Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...

I'm losing my mind on this - I have set jail.sysvipc_allowed=1 in my
/etc/sysctl.conf file as is needed for jails to use the shared memory,
however, they aren't. I know it is turned on on the main system itself:

ipcs -s
Semaphores:
T ID KEY MODE OWNER GROUP

Someone please tell me they have experience with PostgreSQL inside a
FreeBSD jail. I desperately need to get PostgreSQL up and running and
this is the one roadblock. Someone please help. This is what I get in
the jail:

%ipcs -s
ipcs: short read
SVID semaphores facility not configured in the system

Thanks,

Joe

Doug McNaught wrote:

Anyone have any ideas yet? I'm still getting nothing from anyone on this
list or the FreeBSD lists - I'm not complaining that I'm not getting
anything, since all help is out of goodwill - just stating I still have
nothing on this. If anyone has successfully installed PostgreSQL in a
jail on FreeBSD, I'd appreciate the insight. Thanks,

Joe

Joseph Koenig wrote:

Hi Joseph,
Did you ever get any resolution to this problem? I am facing it now and need some
direction.
Thanks
---   Joe   ---

Joseph Koenig wrote: