Re: Setting up Postgresql on Linux

Take a look at your pg_hba.conf file it will be located in your data
directory, on my system (Suse) /var/lib/pgsql/data. That file sets the user
permissions of who is allowed to connect to postgres and to what databases.
In addition you need to make sure that the -i option is used to startup
postgres if you are connecting over TCP/IP. And don't forget you also have
to add the user that you are using to connect through jdbc into the user
list for the database.

Summary
1) pg_hba.conf
2) -i option to enable TCP/IP connections
3) add the jdbc user you will be connecting as to the list of users for the
database.

I hope that helps.

Keith

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Phil Campaigne
Sent: Monday, March 01, 2004 5:22 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Setting up Postgresql on Linux


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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly