Thread: postgres 7.1.1 on Freebsd 4.3?

postgres 7.1.1 on Freebsd 4.3?

From
"Rudy Amid"
Date:
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




Re: postgres 7.1.1 on Freebsd 4.3?

From
Fernando Schapachnik
Date:
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

Re: postgres 7.1.1 on Freebsd 4.3?

From
Jeff Eckermann
Date:
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

Re: postgres 7.1.1 on Freebsd 4.3?

From
Vivek Khera
Date:
>>>>> "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/