Обсуждение: postgres 7.1.1 on Freebsd 4.3?
I hope I got the right newsgroup to ask this question, so here goes: Anyone got Postgres 7.1.1 to work under FreeBSD 4.3? It compiled fine but here's what I got when I ran postmaster: IpcMemoryCreate: shmget(key=5432001, size=1236992, 03600) failed: Cannot allocate memory The Postgres FAQ states that my kernel may not have enough (~10Mb) of shared memory, but to my dismay, I also can't figure out how to tweak that on the freebsd kernel config. If anyone ran across this problem before and have a solution, please let me know. Thanks! Rudy
Why don't you try with the port? If you need to recompile the kernel, take a look at the handbook (probably on /usr/share/doc/handbook or the FreeBSD web site). Regards. En un mensaje anterior, Rudy Amid escribió: > I hope I got the right newsgroup to ask this question, so here goes: > > Anyone got Postgres 7.1.1 to work under FreeBSD 4.3? It compiled fine but > here's what I got when I ran postmaster: > > IpcMemoryCreate: shmget(key=5432001, size=1236992, 03600) failed: Cannot > allocate memory > > The Postgres FAQ states that my kernel may not have enough (~10Mb) of shared > memory, but to my dismay, I also can't figure out how to tweak that on the > freebsd kernel config. > > If anyone ran across this problem before and have a solution, please let me > know. > > Thanks! > Rudy > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org Fernando P. Schapachnik Gerente de tecnología de red y sistemas de información VIA NET.WORKS ARGENTINA S.A. fschapachnik@vianetworks.com.ar Tel.: (54-11) 4323-3381
This probably doesn't help, but: I have had no trouble with PostgreSQL 7.1.2, installed via ports on my FreeBSD 4.3 machine running a GENERIC kernel. (Pure speculation here: try running "ipcclean" and see what happens). --- Fernando Schapachnik <fschapachnik@vianetworks.com.ar> wrote: > Why don't you try with the port? > > If you need to recompile the kernel, take a look at > the handbook > (probably on /usr/share/doc/handbook or the FreeBSD > web site). > > Regards. > > En un mensaje anterior, Rudy Amid escribi�: > > I hope I got the right newsgroup to ask this > question, so here goes: > > > > Anyone got Postgres 7.1.1 to work under FreeBSD > 4.3? It compiled fine but > > here's what I got when I ran postmaster: > > > > IpcMemoryCreate: shmget(key=5432001, > size=1236992, 03600) failed: Cannot > > allocate memory > > > > The Postgres FAQ states that my kernel may not > have enough (~10Mb) of shared > > memory, but to my dismay, I also can't figure out > how to tweak that on the > > freebsd kernel config. > > > > If anyone ran across this problem before and have > a solution, please let me > > know. > > > > Thanks! > > Rudy > > > > > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org > > > > Fernando P. Schapachnik > Gerente de tecnolog�a de red > y sistemas de informaci�n > VIA NET.WORKS ARGENTINA S.A. > fschapachnik@vianetworks.com.ar > Tel.: (54-11) 4323-3381 > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org __________________________________________________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com
>>>>> "RA" == Rudy Amid <radix33@hotmail.com> writes: RA> The Postgres FAQ states that my kernel may not have enough (~10Mb) RA> of shared memory, but to my dismay, I also can't figure out how to RA> tweak that on the freebsd kernel config. No need for a new kernel. Just use sysctl to set the value at runtime, like this, in your /etc/sysctl.conf file (create it if you don't have one already) # tuning for PostgreSQL kern.ipc.shmall=65535 kern.ipc.shmmax=268435456 kern.ipc.shm_use_phys=1 You can run the above with, eg, "sysctl -w kern.ipc.shmall=65535" at the command line as well, at any time. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/