[GENERAL] rubyrep breaks Silver Stripe (MVC frame work) and vis versa.

2011-01-20 Thread Gregory Machin
Hi. I'm new to Postgresql, database replication and Silver Stripe. I have to provide a solution for real time database replication. I was using Rubyrep to do replication to a second database running as Hot standby / Master-Master. The developers failed to tell me that you can't use trigger based r

[GENERAL] advise on performance issues please

2010-11-30 Thread Gregory Machin
Hi this is the first time I'm working with Posgresql other than a defualt install. I have a CentOS 5.5 virtual machine with - 4 virtual cpus , 8 Gig RAM , resource pool set to High (8000) running on a vmware ESXi 4.1 host - 4 x 2.4 GHz cpus AMD 6 cores each, 96 Gig ram, storage is provided by HP

[GENERAL] Adivice on master - master replication.

2010-10-28 Thread Gregory Machin
Hi I'm new to Posgresql. I have been requested to setup application level HA. The picture is, I will have 2 web servers behind 2 new work load balancers, so should one fail the NLB's will redirect traffic to the remaining server. I need a similar scenario for the Pgsql servers. >From my reading I