synchronous replication for PG

[bodymindarts]

Currently PG replicas are potentially a bit behind the master, so there could be data loss in the event of a failover

[jamessewell]

As part of the simple version of you might want to include application_name in primary_conninfo in recovery.conf:

primary_conninfo = 'application_name= '{{cfg.replication.application_name}} user={{cfg.replication.name}} password={{cfg.replication.password}} host={{svc.leader.sys.ip}} port={{cfg.port}} sslmode=prefer sslcompression=1'

Even if you don't use it to start with, it allows grouping of standbys if you would like (sync group, async group etc....)

[bodymindarts]

Added application_name 1d2d8a1