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