Multiple Postmasters on Beowulf cluster

From: "Jan Hartmann" <jhart(at)frw(dot)uva(dot)nl>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Multiple Postmasters on Beowulf cluster
Date: 2002-07-27 15:24:03
Message-ID: DIEALLGCLLCNIHBDCMAEKEFJCDAA.jhart@frw.uva.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I am using Postgresql with PostGis and the Minnesota MapServer on a Beowulf
cluster for web-mapping applications. It runs fine on one node, producing
very fast interactive maps for an Apache/PHP web server. However, the
cluster consists of 45 nodes, all using a shared user file system. Is it
possible to start up a postmaster on every node, using the same database?
The backend processes themselves would be completely autonomous, but they
would have to share their data from the same source. To simplify things,
only read-access is necessary. Would this be possible, and if so, how can
the different postmasters be made to use a different postmaster.pid file
(which is located in the shared data directory)?

It would be an interesting way for using the cluster, as the individual map
layers can be independently constructed on different nodes, and only finally
have to be put together in a complete map. Essentially, MapServer constructs
a map from layers, where each layer originates from an individual PostgreSQL
connection, even when using only one database. In a cluster solution
therefore, no communication between the nodes would be required. Even the
data could be distributed over the nodes and put into different databases,
but this would inevitably lead to much duplication and a set of databases
that would be very difficult to administer. In the archives, I saw some
mention of work in progress on distributed databases, but for this I don't
need much in the way of distributed facilities, just reading shared data.

Any help would be very much appreciated. It certainly would be a great
example of PostgrSQL's advanced geometrical capabilities!

Jan Hartmann
Department of Geography
University of Amsterdam
jhart(at)frw(dot)uva(dot)nl

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-07-27 15:34:11 Re: Multiple Postmasters on Beowulf cluster
Previous Message Ludwig Lim 2002-07-27 02:46:44 Re: Can't get pgaccess to run