Re: [GENERAL] General Advice for avoiding concurrency during schema migrations

2014-03-24 Thread Ken Barber
> Do you really need to allow web server connections to the database during a > schema migration ? Why not locking them up either with pg_hba.cong or a > firewal rule or symply shut it off temporarily ? So this would be ideal if we could control the situation 100%, to be clear our software is a sh

[GENERAL] General Advice for avoiding concurrency during schema migrations

2014-03-21 Thread Ken Barber
Hi there, I was just wondering if anyone has some general advice for how to ensure a schema migration for an application has exclusivity during its run. This is to avoid silly things like, if someone leaves an application server running during migration the migration should be able to lock someho