Re: PG 7.0.3 & RH 7 IPC problems? - Mailing list pgsql-admin

From DHSC Webmaster
Subject Re: PG 7.0.3 & RH 7 IPC problems?
Date
Msg-id 3AC36EF0.12A3E9E4@dhs-club.com
Whole thread Raw
In response to PG 7.0.3 & RH 7 IPC problems?  (DHSC Webmaster <webmaster@dhs-club.com>)
Responses Re: PG 7.0.3 & RH 7 IPC problems?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
It would appear that either my icps is not working or that everything is
alright.
(don't know enough about what to expect to know!)
bash-2.04$ ipcs

------ Shared Memory Segments --------
key       shmid     owner     perms     bytes     nattch    status

------ Semaphore Arrays --------
key       semid     owner     perms     nsems     status

------ Message Queues --------
key       msqid     owner     perms     used-bytes  messages

bash-2.04$

Tom Lane wrote:
>
> DHSC Webmaster <webmaster@dhs-club.com> writes:
> > [postgres@atl01371 data]$ nohup postmaster -D /usr/local/pgsql/data -i
> > -B 128 -N 64 > /usr/local/pgsql/data/logs/log.txt
> > IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
> > size=2048000, permission=600
>
> Not sure about Linux, but on HPUX there are two possible reasons for
> shmget to return EINVAL:
>
>           [EINVAL]       size is less than the system-imposed minimum or
>                          greater than the system-imposed maximum.
>
>           [EINVAL]       A shared memory identifier exists for key but the
>                          size of the segment associated with it is less
>                          than size and size is not equal to zero.
>
> In other words, you could get this if there is an old segment of smaller
> size and the same key still laying about, which there might well be if
> you were foolish enough to kill -9 the old postmaster.  Use ipcs and
> ipcrm to check and clean up.
>
> 7.1 uses a slightly different approach that hopefully avoids this
> particular failure scenario...
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
Bill MacArthur
Webmaster
DHS Club

pgsql-admin by date:

Previous
From: Stefan Huber
Date:
Subject: Re: PG 7.0.3 & RH 7 IPC problems?
Next
From: Jaume Teixi
Date:
Subject: Re: search on accents -> Why not include this function