Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199311190417.UAA27841@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Message-Id: <199311190417.UAA25925@faerie.CS.Berkeley.EDU>
From: aoki@postgres.Berkeley.EDU (Paul M. Aoki)
To: qihe@sbcs.sunysb.edu (Qi He)
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: db owner 
In-reply-to: Your message of Thu, 18 Nov 1993 22:41:18 -0500 
	     <199311190341.AA16537@sbcs.sunysb.edu> 
Date: Thu, 18 Nov 93 20:17:03 -0800
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Thu, 18 Nov 93 20:17:13 -0800
Resent-XMts: smtp

qihe@sbcs.sunysb.edu (Qi He) writes:
> I can createdb, but I can not do any operation on the db I created, since the
 dbis owned by "postgres" user account, not my account?!
> Why the database owner is not me, though I created it through my account?!
> 
> I can not run my database, and I can not kill the postmaster process either,
> though I could start it running. I guess these are the same cause?

normally, all of the data is owned by the "postgres" user.  you access 
the data by connecting an application (such as monitor) to processes 
started by the postmaster, which should have the "postgres" user's uid.
you should be able to access the database using the monitor program; you 
should not be able to "ls" or "rm" your data files directly.

if you started the postmaster as "qihe" and it is now running as 
"postgres", then the postmaster has been installed setuid.  if this
is causing you problems, you should talk to the person who installed
the postgres system on your machine (whoever that is..).
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki