Setting up Postgresql on Linux

From: Phil Campaigne <pcampaigne(at)charter(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Setting up Postgresql on Linux
Date: 2004-03-01 23:22:09
Message-ID: 4043C5A1.70208@charter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

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?

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

thanks,
Phil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron St-Pierre 2004-03-01 23:47:20 Re: How to drop sequence?
Previous Message scott.marlowe 2004-03-01 22:57:59 Re: sql query to get field types