Search Postgresql Archives

Re: Compiling/Installing as a non-admin user

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux