On Mar 2, 2006, at 2:44 PM, Scott Marlowe wrote:
> On Thu, 2006-03-02 at 14:41, Andrew Watkins wrote:
>> I'm writing a parallel/distributed application that assesses the
>> performance impact of frequent insertions/selects to databases on
>> parallel file systems in a linux cluster environment. Currently, the
>> application calls for a database server to be running on each node of
>> the cluster. Since my end-users may or may not have root access to the
>> machines in the various clusters being used, I'm installing postgres
>> from within the user's account to facilitate the starting and stopping
>> of the postmaster without the need of root access. My general
>> question
>> is if anyone has experience with such a situation where the database
>> server would need to be started on each machine in a parallel
>> environment. If so, are there any suggestions for working with such a
>> condition?
>
> You could set up ssh keys with no passphrase and use ssh to do it in a
> short shell script.
>
Thanks. I suppose my question is less about the mechanisms for actually
starting the servers and more about where to install the servers, where
they should be running, etc. For example, if I'm using a shared file
system across each node in the cluster and postgres has been installed
in, say, /home/user/pgres, and initdb has initialized the database on,
say, /home/user/pgres/data, then it would seem like there would end up
being conflicts in file names when trying to launch a local server on
each node. On the other hand, if there is disk space local to each
node, then running the servers there would not allow for the assessing
of the impact on a parallel file system.
----------------------
Andrew Watkins, PhD
Department of Computer Science and Engineering
Mississippi State University
Box 9637, Mississippi State, MS, 39762
Office: (662) 325-7515
Fax: (662) 325-8997
http://www.cse.msstate.edu/~andrew