postgres 7.1.1 on Freebsd 4.3?

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/