Re: Setting up Postgresql on Linux

On Mon, 1 Mar 2004, Phil Campaigne wrote:

> Hello,
> I originally installed postgresql as root user and now I am setting up a 
> development environment with cvs and a java ide and tomcat. I have 
> everything with the exception of postgresql integreted using a non-root 
> user.
> THe process I am using is  to logon as postges and start the database 
> and do queries from the command line using psql. Then I logoff and logon 
> as phil and start tomcat and my java ide.
> 
> 1.Is there a better way to start the database and the web application?

Yes, you can edit your /etc/rc.d/rc.local file and add lines something 
like this:

su - postgres -c -- 'pg_ctl start -l $PGDATA/pgsql.log'
su - httpd -c -- 'apachectl start'

etc...

> 2. During setup of postgresql I chown and ghgrp the /usr/local/pgsql 
> directoy tree to postgres?

Not necessary.  You just need to chown postgres.postgres whatever 
directory you're putting in $PGDATA.

> 3.However my development environment(i.e. jdbc connection from my 
> application) doesn't seem to have permission to access to all the files 
> it needs in postgres?

Someone else mentioned it, it's in pg_hba.conf. Also check your firewall 
installation.

> 4. Is is best to install postgresql as user "phil" in order to gain 
> access for my integrated develoment environment?

Not needed.  If you createuser as the postgres superuser the user phil and 
assign him the power to add users, you make him a superuser and he will 
have every bit as much power as the postgres user.  You might want to make 
two accounts, one for you as a superuser, and one for the application 
which is just a normal user with security to keep it in place.

Enjoy!