Re: [Netdisco] netdisco read-only server for pg9 hot standby

[Ben C. <ben...@gm...>]

Hi,
I've discovered what looks like a good alternative to altering the netdisco
install in any way. The slony replication system for postgres can handle
replicating only certain tables. I hope that by leaving out log, user_log,
process, sessions from the replication set (so these tables remain writable)
netdisco should be kept happy.
I have slony up and running on a test database and it looks like it can
handle a heavy load such as when running a macsuck on the network. I will
update the list with how it goes.
cheers,
B

On Tue, Jan 11, 2011 at 8:04 AM, <pe...@go...> wrote:

>
> to add a thought to Jeroen's good reply...
>
> On 09/01/2011 07:27, Ben Carbery wrote:
> > Can any of the devs confirm whether or not this is worth trying to
> > do? If netdisco fundamentally relies on session information being in
> > the database and this can't be easily changed, then I am thinking
> > not..
>
> My guess would be that if you enabled "Apache Auth" in Netdisco
> config (and Apache-Netdisco config) then the users and session
> tables would not be touched.
>
> If you have a more public frontend then this could use Apache Auth
> (as I used to do, with our org's single-sign-on and a "require user
> ..." or "require group ..." statement in Apache conf). It shouldn't
> stop any other instance using a different auth mechanism.
>
> Probably a good idea to disable the admin panel features altogether
> in this case as well.
>
> regards,
> oliver.
>
>
> ------------------------------------------------------------------------------
> Gaining the trust of online customers is vital for the success of any
> company
> that requires sensitive data to be transmitted over the Web.   Learn how to
> best implement a security strategy that keeps consumers' information secure
> and instills the confidence they need to proceed with transactions.
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> Netdisco mailing list
> net...@li...
> https://lists.sourceforge.net/lists/listinfo/netdisco-users
>



-- 
 -------------------------------------------------------------------------------------------------------------------------------------------------------
"Because it that the times revive as time is fresh somehow, and it to feel
wins why, and, as for it, all forget an old thing" - Japanese saying