Ritesh Nadhani wrote on 01.11.2006 07:51:
Hello All
Me and my professor are planning to work upon machine learning in
postgresql over tsearch2. So I have some questions:
We have a server where Postgresql is running without any problem with
postgres username and admin rights. I have a user account in that
server. I plan to compile and run another postgresql for our testing so
I was thinking of how to do that? My prior knowledge of using postgresql
has always been as admin where I have full rights.
As I see, using the default MAKE for postgresql will set the data
directory etc. in /usr/local/data etc which I dont have access to as a
user.
So I would like to compile and run postgresql as a normal user with
every thing like data kept in my usr directory. I should be able to run
the instance over separate port and can start and stop it.
Basically, I want to run the server as in user mode....
How should I configure the MAKE and INSTALL in this circumstances? What
are your suggestions....
I have no experience with PG on Unix/Linux so if I'm missing something please
bear with me.
The port where postmaster is listening on is defined in postgresql.conf which is
local to the data directory.
Couldn't you simply initdb using e.g. $HOME/pgdata, then edit
$HOME/pgdata/postgresql.conf change the port and then start (the already
installed) postmaster from within your acount using the -D switch pointing to
$HOME/pgdata?
As far as I can tell, all you'd need is execute rights on the installed
postmaster (maybe that's the problem...)
Thomas