[GENERAL] plsql / plpgsql code coverage tool, static analysis tool

Hi PG Community, Does anyone know any code coverage tool and static analysis tool for PL/SQL or PL/pgSQL code? Thanks~ Ning

[GENERAL] Trigger function on Warm Standby

Hi all, I have a Primary Standby setup with streaming replication. Trigger is created on a table, and all it does it to log a message. The trigger works as expected on Primary, however, I don't see the same on standby. I alter the table to have ENABLE ALWAYS TRIGGER, I verified the setting on bo

[GENERAL] Streaming Replication Failover

Hi, I have a cluster of 3 nodes Primary is connected by StandbyA (streaming), Standby A is connected by Standby B (streaming). I failed over the cluster 1) stop primary 2) promoted StandbyA Now i see from syslog on Standby B that it is complaining about the timeline mismatch. Replication Status f

Re: [GENERAL] Streaming Replication

Hi Albe, Thanks for your kind response. The wordings is confusing, it gives me impression that the recovery is going on. On Tue, Jan 15, 2013 at 2:09 AM, Albe Laurenz wrote: > ning chan wrote: > > I am new to PG Streaming Replication and I have a simple question > hopefully someon

[GENERAL] Streaming Replication

Hi, I am new to PG Streaming Replication and I have a simple question hopefully someone can answer this easily. I setup a Primary Hot Standby and they are connecting each other without problem. Looking at the wal sender process, both servers pointing to the same location as follow: Primary: postg