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 (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

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 (AT) postgresql (DOT) org
[mailtogsql-general-owner (AT) postgresql (DOT) org] On Behalf Of Phil Campaigne
Sent: Monday, March 01, 2004 5:22 PM
To: pgsql-general (AT) postgresql (DOT) 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 (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

On 01/03/2004 23:22 Phil Campaigne wrote:
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.

It doesn't need any postgres files. It communicates via tcp/ip. Keith has
already posted the config changes you need to make.

See above.

--
Paul Thomas
+------------------------------+---------------------------------------------+
+------------------------------+---------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Mon, 1 Mar 2004, Phil Campaigne wrote:

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...

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

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

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!


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Phil Campaigne wrote:

http://www.postgresql.org/docs/7.4/s...ter-start.html
especially section 16.3 as it pertains to linux (assuming that's your
os). Below are some of the steps I use when I install postgres on a new
machine, check out steps 10 and 11 specifically:

---- my instructions ----
8. Install:

# cd /usr/local/postgresql-7.x
# make install
# make install-all-headers
# cd /usr/local
# chown -R postgres.postgres pgsql


9. Initialize the database as user postgres:

# su - postgres
# initdb -E UNICODE -D /usr/local/pgsql/data


10. Configure (as root) the PostgreSQL SysV Script. This script is
useful for starting, stopping, and checking the status of PostgreSQL.

# cd /usr/local/src/postgresql-7.x
# cp contrib/start-scripts/linux /etc/init.d/postgres
# chmod 755 /etc/init.d/postgres

To have PostgreSQL start automatically when the computer boots add
symbolic links from the correct /etc/rc*.d/ directories to
/etc/init.d/postgres. If the normal runlevel is 3 then you really only
need to add it to rc3.d:

# ln -s /etc/init.d/postgres /etc/rc2.d/S85postgres
# ln -s /etc/init.d/postgres /etc/rc3.d/S85postgres

etc ...

11. Start PostgreSQL for the first time:

# /etc/init.d/postgres start


12. Create a new db:

# su - postgres
$ createdb testdb
$ psql testdb

----\ my instructions ----
Ron

*Note:* these are taken from the book Practical Postgres by Worsley and
Drake and are slightly(? can't remember, it's been so long since I made
the list) modified.




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)