agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedIpcMemoryAttach
2+ messages / 2 participants
[nested] [flat]
* IpcMemoryAttach
@ 1994-08-04 10:07 Bernd Froehlich <bfroehli@AWI-Bremerhaven.DE>
1994-08-04 19:09 ` Re: IpcMemoryAttach Paul M. Aoki <aoki@CS.Berkeley.EDU>
0 siblings, 1 reply; 2+ messages in thread
From: Bernd Froehlich @ 1994-08-04 10:07 UTC (permalink / raw)
To: legacy
I got some strange behavior from Postgres.
Last week I tried to start the postmaster and got the following error message:
edvs6% postmaster &
[1] 3284
edvs6% IpcMemoryAttach: shmat() failed: Permission denied
The funny thing is: when I was logged in under my own name I could start the postmaster, only as postgres user it was not possible to get it running.
Even installing postgres again did not help.
Now I experimented a little and found out that when I run newbki and specify my own login then I can start the postmaster as user postgres and get the error when I try to start it under my login.
Since the manuel states that you always should use newbki with the postgres login I am not sure what to do. How can I get things straight???
P.S. I am working on a SUN Sparc station
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: IpcMemoryAttach
1994-08-04 10:07 IpcMemoryAttach Bernd Froehlich <bfroehli@AWI-Bremerhaven.DE>
@ 1994-08-04 19:09 ` Paul M. Aoki <aoki@CS.Berkeley.EDU>
0 siblings, 0 replies; 2+ messages in thread
From: Paul M. Aoki @ 1994-08-04 19:09 UTC (permalink / raw)
To: Bernd Froehlich <bfroehli@AWI-Bremerhaven.DE>; +Cc: legacy
bfroehli@AWI-Bremerhaven.DE (Bernd Froehlich) writes:
> edvs6% postmaster &
> [1] 3284
> edvs6% IpcMemoryAttach: shmat() failed: Permission denied
this usually means you have a shared memory segment allocated as
the "wrong" user (meaning a different user than the user you now
want to start postgres as). this is generally a symptom of killing
off postmasters with "kill -9" and is the main reason why the manual
says not to use "kill -9".
use "ipcs" to see what segments are there and use "ipcclean" (as
the user who owns the segments).
--
Paul M. Aoki | University of California at Berkeley
aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division (#1776)
| Berkeley, CA 94720-1776
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1994-08-04 19:09 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1994-08-04 10:07 IpcMemoryAttach Bernd Froehlich <bfroehli@AWI-Bremerhaven.DE>
1994-08-04 19:09 ` Paul M. Aoki <aoki@CS.Berkeley.EDU>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox