| From: | Dimitri Maziuk <dmaziuk(at)bmrb(dot)wisc(dot)edu> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: unorthodox use of PG for a customer |
| Date: | 2018-08-24 19:54:57 |
| Message-ID: | 4a7fa8d9-46c2-2ffe-1fd7-fde958603ad2@bmrb.wisc.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 08/24/2018 02:35 PM, Andrew Kerber wrote:
> Unless I am missing something, it sounds like you might be able to do this
> with an nfs export shared to each workstation.
That's no different from polling the central database though, you're
just using nfs server and files instead of a db server and queries.
A compute cluster has to have a manager node that has all the state. The
way to do what he wants is to query that manager from each workstation
and keep the results in the local state database. Whether that is
actually feasible/doable in his particular case is another question.
--
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Jeffcoat | 2018-08-25 00:43:32 | Re: Join condition parsing puzzle |
| Previous Message | Andrew Kerber | 2018-08-24 19:35:24 | Re: unorthodox use of PG for a customer |