On 01/03/2004 23:22 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?
Start PostgreSQL off as service (it's probably there already but configured to start on power-up/reboot). In a production environment I set tomcat up as a service as well. In a developmemt environment, I install/run it under my user.
2. During setup of postgresql I chown and ghgrp the /usr/local/pgsql directoy tree to postgres?
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?
It doesn't need any postgres files. It communicates via tcp/ip. Keith has already posted the config changes you need to make.
4. Is is best to install postgresql as user "phil" in order to gain access for my integrated develoment environment?
See above.
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller Business |
| Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
