*BSD News Article 95990


Return to BSD News archive

Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!news.mira.net.au!news.netspace.net.au!news.mel.connect.com.au!news.mel.aone.net.au!mackay02.cqit.qld.edu.au!usenet
From: Robert <robert@chalmers.com.au>
Newsgroups: comp.unix.bsd.freebsd.misc
Subject: No Permissions under postgres user from shem
Date: Fri, 23 May 1997 15:03:20 +1000
Organization: chalmers.com.au
Lines: 50
Message-ID: <33852518.5658@chalmers.com.au>
Reply-To: robert@chalmers.com.au
NNTP-Posting-Host: remote2.cqit.qld.edu.au
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 3.0 (Win95; I)
Xref: euryale.cc.adfa.oz.au comp.unix.bsd.freebsd.misc:41475

Hi,
compiled the postgres,V6 fine, and everything appears to be ok,
however, on trying to run it. Start up the postgres server, I run
into permission problems,

If I run as user "postgres", it wont start because "postgres" doesn't
have permissions.
The log file tells all. The FAQ for Postgres isn't a lot of help. It's
a FreeBSD permissionss thing.
------------------
IpcMemoryCreate: memKey=155356405 , size=24588 , permission=448
IpcMemoryCreate: shmget(..., create, ...) failed: Permission denied
This type of error is usually caused by improper
shared memory or System V IPC semaphore configuration.
See the FAQ for more detailed information
IpcMemoryAttach: shmat() failed: Permission denied
This type of error is usually caused by improper
shared memory or System V IPC semaphore configuration.
See the FAQ for more detailed information
------------------

If I run as user "root" ( I know, a no-no )
I get,
------------------
"root" execution of the PostgreSQL backend is not permitted
It is highly recommended that the backend be started under it's own
userid
to prevent possible system security compromise. This can be accomplished
by placing the following command in the PostgreSQL startup script.
echo "postmaster -B 256 >/var/log/pglog 2>&1 &" | su - postgres
-------------------
But, of course, having done that, it then wont start because the
permissions are wrong.

System V bits are compiled into the FBSD kernel, and ipsc shows that
the relevant bits have "root wheel" , rw only permissions set.

Can someone tell me please how to get the permissions set so that
postgres
can use the mem bits please.

thanks
Robert


-- 
http://www.chalmers.com.au Books-New & Secondhand  Support Whirled Peas.
Agents for CIBTC. Associate of Amazon.com, and Partner Program with iBS.
Books about China, books from China.         Sheng huo jiu shi dou zheng
Business Links in Dalian, and Beijing.          Building the China Trade