Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA25995; Tue, 25 Feb 92 12:00:08 -0800
Message-Id: <9202252000.AA25995@postgres.Berkeley.EDU>
From: mao@postgres.Berkeley.EDU (Mike Olson)
Subject: Re: Starting postmaster
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Tue, 25 Feb 92 11:33:24 PST.
             <9202251933.AA25303@postgres.Berkeley.EDU> 
Date: Tue, 25 Feb 92 12:01:51 PST

In message <9202251933.AA25303@postgres.Berkeley.EDU> you write:

> > if [ -f $POSTGRESHOME/bin/postmaster ]; then
> > 	$POSTGRESHOME/bin/postmaster & echo 'postmaster'
> > fi

try
	if [ -f $POSTGRESHOME/bin/postmaster ]; then
		su postgres -c $POSTGRESHOME/bin/postmaster & echo 'postmaster'
	fi

this will be sure that the postmaster is running as postgres, rather than
as root.  when postmaster forks off a backend, it tries to find its uname
in the database pg_user table, and root doesn't appear, so it will die.

not absolutely sure that this will solve your problem, but it's more correct
than the rc line you show above.

					mike