multiple postgresql servers in multiple jails?

[Oliver Peter]

On Thu, Oct 25, 2007 at 04:38:53PM +0200, Oliver Fromme wrote:
> Oliver Peter wrote:
>  > Oliver Fromme wrote:
>  > > Oliver Peter wrote:
> ...
> Can you please give the output from "ipcs -M" and "ipcs -p"?

Here you go:

% sudo ipcs -M
shminfo:
        shmmax:    134217728    (max shared memory segment size)
        shmmin:            1    (min shared memory segment size)
        shmmni:          192    (max number of shared memory identifiers)
        shmseg:          128    (max shared memory segments per process)
        shmall:        65536    (max amount of shared memory in pages)


% sudo ipcs -p
Message Queues:
T           ID          KEY MODE        OWNER    GROUP           LSPID        LRPID

Shared Memory:
T           ID          KEY MODE        OWNER    GROUP            CPID         LPID
m        65536      5432001 --rw-------       70       70         1064         1064
m       131073      5473001 --rw-------     1073       70         6293         6293
m       131074      5472001 --rw-------     1072       70         6545         6545
m       131075      5471001 --rw-------     1071       70         6797         6797

Semaphores:
T           ID          KEY MODE        OWNER    GROUP
s        65536      5432001 --rw-------       70       70
s        65537      5432002 --rw-------       70       70
s        65538      5432003 --rw-------       70       70
s        65539      5432004 --rw-------       70       70
s        65540      5432005 --rw-------       70       70
s        65541      5432006 --rw-------       70       70
s        65542      5432007 --rw-------       70       70
s       131079      5473001 --rw-------     1073       70
s       131080      5473002 --rw-------     1073       70
s       131081      5473003 --rw-------     1073       70
s       131082      5473004 --rw-------     1073       70
s       131083      5473005 --rw-------     1073       70
s       131084      5473006 --rw-------     1073       70
s       131085      5473007 --rw-------     1073       70
s       131086      5472001 --rw-------     1072       70
s       131087      5471001 --rw-------     1071       70
s       131088      5471002 --rw-------     1071       70
s       131089      5471003 --rw-------     1071       70
s       131090      5471004 --rw-------     1071       70
s       131091      5471005 --rw-------     1071       70
s       131092      5471006 --rw-------     1071       70
s       131093      5471007 --rw-------     1071       70


% sudo ipcs -bm
Shared Memory:
T           ID          KEY MODE        OWNER    GROUP           SEGSZ
m        65536      5432001 --rw-------       70       70     38076416
m       131073      5473001 --rw-------     1073       70     38076416
m       131074      5472001 --rw-------     1072       70      1654784
m       131075      5471001 --rw-------     1071       70     38076416


% ./jps | grep postgres
     1  1064 70      /usr/local/bin/postgres -D /usr/local/pgsql/data
     1  1068 70      postgres: writer process    (postgres)
     1  1069 70      postgres: stats collector process    (postgres)
     5  6293 1073    /usr/local/bin/postgres -D /usr/local/pgsql/data
     5  6295 1073    postgres: writer process    (postgres)
     5  6296 1073    postgres: stats collector process    (postgres)
     6  6545 1072    /usr/local/bin/postgres -D /usr/local/pgsql/data
     6  6547 1072    postgres: writer process    (postgres)
     6  6548 1072    postgres: stats collector process    (postgres)
     7  6797 1071    /usr/local/bin/postgres -D /usr/local/pgsql/data
     7  6799 1071    postgres: writer process    (postgres)
     7  6800 1071    postgres: stats collector process    (postgres)

> The "jps" script could be useful:
> 
> http://www.secnetix.de/~olli/scripts/jps

Excellent stuff there :)

-- 
Oliver PETER, eMail: hoschi at mouhaha.de, ICQ# 113969174
"Worker bees can leave.  Even drones can fly away.
                         The Queen is their slave."
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20071026/57d4fef1/attachment.pgp