I have all of these on my server, but postgres does not fail when using
semaphores. What happens when you 'gmake check'?
Thanks,
Corey
[EMAIL PROTECTED]
Sent by: To: [EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
tgresql.org Subject: Re: [ADMIN] 7.4.3 initdb:
could not create
semaphores
07/02/2004 09:33 AM
Re:
i launched http://developer.postgresql.org/docs/pgsql/contrib/ipc_check/:
-bash-2.05b# ./ipc_check.pl -B 64
shared memory enabled: 32768 kB available
no changes to kernel required for a "-B 64" setting
==========================
and my:
bash-2.05b# sysctl -a |grep shm
kern.ipc.shmmax: 33554432
kern.ipc.shmmin: 1
kern.ipc.shmmni: 192
kern.ipc.shmseg: 128
kern.ipc.shmall: 8192
kern.ipc.shm_use_phys: 0
shm 5 20K 25K 1423 16,1024,16384
bash-2.05b# sysctl -a |grep sem
kern.ipc.semmap: 30
kern.ipc.semmni: 10
kern.ipc.semmns: 60
kern.ipc.semmnu: 30
kern.ipc.semmsl: 60
kern.ipc.semopm: 100
kern.ipc.semume: 10
kern.ipc.semusz: 92
kern.ipc.semvmx: 32767
kern.ipc.semaem: 16384
acpisem 14 2K 2K 14 128
sem 4 7K 8K & nbsp; 72 16,1024,4096
debug.acpi_semaphore_debug: 0
p1003_1b.semaphores: 0
p1003_1b.sem_nsems_max: 0
p1003_1b.sem_value_max: 0
bash-2.05b# uname -a
FreeBSD Server 5.1-RELEASE-p16 FreeBSD 5.1-RELEASE-p16 #2: Mon Mar 29
08:44:10 CEST 2004 [EMAIL PROTECTED]:/usr/src/sys/i386/compile/MYKERNEL i386
bash-2.05b# pg_ctl --version
pg_ctl (PostgreSQL) 7.4.3
and still i can not create initdb....
I remember i had identical problem with FreeBSD and Postgres in the past,
but i can not remind what have i done to solve it...
Could anybody help ?
Thanx
Michal
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
