Re: Yet another infrastructure problem - Mailing list pgsql-www

From Magnus Hagander
Subject Re: Yet another infrastructure problem
Date
Msg-id 49038677.3050603@hagander.net
Whole thread Raw
In response to Re: Yet another infrastructure problem  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-www
Robert Treat wrote:
> On Saturday 25 October 2008 04:23:34 Magnus Hagander wrote:
>> The login system would also be good to have distributed, but it's used
>> by orders of magnitude less number of people. But if we replicate the
>> database off to the other machine, it should be possible to point the
>> logins on both machines as well - it's a simple pl/pgsql function that
>> needs to be called. We'll just need to deal with the "last logged in"
>> part that won't work then.
>>
> 
> If you used plproxy rather plpgsql, i think you could eliminate this problem. 
> 

Does pl/proxy actually help with that? I haven't actually used it, but
from what I can tell dealing with failover is still on the TODO list for
it ("RUN ON ANY: if one con failed, try another"). Or?

//Magnus



pgsql-www by date:

Previous
From: Koen Martens
Date:
Subject: Re: hosting postgresql.{nl,be}
Next
From: Russell Smith
Date:
Subject: Re: Yet another infrastructure problem