Thread: 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
----- 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: > > > 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...
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
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...
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...
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)
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