pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL in FreeBSD jails
2+ messages / 2 participants
[nested] [flat]

* PostgreSQL in FreeBSD jails
@ 2005-04-26 11:24 Alexander Rusinov <boot@eurocom.od.ua>
  2005-04-26 18:25 ` Re: PostgreSQL in FreeBSD jails Mario Soto Cordones <msotocl@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Alexander Rusinov @ 2005-04-26 11:24 UTC (permalink / raw)
  To: pgsql-admin

Hi,

I need to run a number of PostgreSQL servers in different FreeBSD jails. 
I managed to run a first instance of PostgreSQL server in a jail, but 
after I launch a new server in another jail the first one starts to 
return an error messages like the following:

semctl(1507328, 4, SETVAL, 0) failed: Invalid argument

The problem in general is: only one instance of PostgreSQL server 
normally processes clients' connections, all of the others return semctl 
errors.

The system is FreeBSD 5.4-PRERELEASE. SEM and SHM sysctl setting are:

# sysctl -a | grep shm
kern.ipc.shmmax: 100000000
kern.ipc.shmmin: 1
kern.ipc.shmmni: 192
kern.ipc.shmseg: 128
kern.ipc.shmall: 32768
kern.ipc.shm_use_phys: 0
kern.ipc.shm_allow_removed: 0

# sysctl -a | grep sem
kern.ipc.semmap: 256
kern.ipc.semmni: 256
kern.ipc.semmns: 512
kern.ipc.semmnu: 256
kern.ipc.semmsl: 60
kern.ipc.semopm: 100
kern.ipc.semume: 10
kern.ipc.semusz: 92
kern.ipc.semvmx: 32767
kern.ipc.semaem: 16384

Trying to solve the problem I've set the following in postgresql.conf files:
max_connections = 5
shared_buffers = 100

Please help! What am I doing wrong?

-- 
Alexander Rusinov




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: PostgreSQL in FreeBSD jails
  2005-04-26 11:24 PostgreSQL in FreeBSD jails Alexander Rusinov <boot@eurocom.od.ua>
@ 2005-04-26 18:25 ` Mario Soto Cordones <msotocl@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Mario Soto Cordones @ 2005-04-26 18:25 UTC (permalink / raw)
  To: Alexander Rusinov <boot@eurocom.od.ua>; +Cc: pgsql-admin

2005/4/26, Alexander Rusinov <boot@eurocom.od.ua>:
> Hi,
> 
> I need to run a number of PostgreSQL servers in different FreeBSD jails.
> I managed to run a first instance of PostgreSQL server in a jail, but
> after I launch a new server in another jail the first one starts to
> return an error messages like the following:
> 
> semctl(1507328, 4, SETVAL, 0) failed: Invalid argument
> 
> The problem in general is: only one instance of PostgreSQL server
> normally processes clients' connections, all of the others return semctl
> errors.
> 
> The system is FreeBSD 5.4-PRERELEASE. SEM and SHM sysctl setting are:
> 
> # sysctl -a | grep shm
> kern.ipc.shmmax: 100000000
> kern.ipc.shmmin: 1
> kern.ipc.shmmni: 192
> kern.ipc.shmseg: 128
> kern.ipc.shmall: 32768
> kern.ipc.shm_use_phys: 0
> kern.ipc.shm_allow_removed: 0
> 
> # sysctl -a | grep sem
> kern.ipc.semmap: 256
> kern.ipc.semmni: 256
> kern.ipc.semmns: 512
> kern.ipc.semmnu: 256
> kern.ipc.semmsl: 60
> kern.ipc.semopm: 100
> kern.ipc.semume: 10
> kern.ipc.semusz: 92
> kern.ipc.semvmx: 32767
> kern.ipc.semaem: 16384
> 
> Trying to solve the problem I've set the following in postgresql.conf files:
> max_connections = 5
> shared_buffers = 100
> 
> Please help! What am I doing wrong?
> 
> --
> Alexander Rusinov
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
> 


-- 
cordialmente,

Ing. Mario Soto Cordones



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-04-26 18:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-26 11:24 PostgreSQL in FreeBSD jails Alexander Rusinov <boot@eurocom.od.ua>
2005-04-26 18:25 ` Mario Soto Cordones <msotocl@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox