Re: [ADMIN] [pgsql-admin] JCR (Apache Jackrabbit) locking when using Postgres, not with MySQL

2012-09-03 Thread Gary Webster
On Wed, Aug 29, 2012 at 10:17 PM, Craig Ringer wrote: > On 08/30/2012 03:37 AM, Gary Webster wrote: > >> Hello. >> The subject says most of what I know at this point. >> >> We are still not getting along with Apache Jackrabbit. >> After a few hours of using Postgres as the Persistence Manager, the

Re: [ADMIN] [pgsql-admin] JCR (Apache Jackrabbit) locking when using Postgres, not with MySQL

2012-09-03 Thread Gary Webster
On Thu, Aug 30, 2012 at 3:33 AM, Albe Laurenz wrote: > Gary Webster wrote: > > The subject says most of what I know at this point. > > > > We are still not getting along with Apache Jackrabbit. > > After a few hours of using Postgres as the Persistence Manager, the > JCR gets stuck, apparently on

[ADMIN] PG 9.1 Looking for old WAL when promoting from recovery to master

2012-09-03 Thread David Morton
I'm implementing replica servers which will use a trigger file to promote from hot standby to full read/write. I've configured streaming replication as well as a recovery.conf which copies old WAL files from a repository if required. When placing the trigger file the system assumes the read/write