Thread: cannot initdb

cannot initdb

From
Joseph Koenig
Date:
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

Re: cannot initdb

From
"Marin Dimitrov"
Date:
----- 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. "




Re: cannot initdb

From
Doug McNaught
Date:
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...

Re: cannot initdb

From
Joseph Koenig
Date:
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:
>
> > 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...

Re: cannot initdb

From
Doug McNaught
Date:
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...

Re: cannot initdb

From
Serkan Bektaş
Date:
 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





Re: cannot initdb ; semget(key=1, num=17, 03600) failed , FreeBSD

From
Serkan Bektaş
Date:
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





Re: cannot initdb

From
Joseph Koenig
Date:
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:
>
> 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...

Re: cannot initdb

From
Doug McNaught
Date:
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...

Re: cannot initdb

From
Joseph Koenig
Date:
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:
>
> 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:
> >
> > 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...
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: cannot initdb

From
Joseph Maxwell
Date:
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:

> 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:
> >
> > 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:
> > >
> > > 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...
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org