Re: [GENERAL] max_connections reached in postgres 9.3.3

2014-06-19 Thread Borislav Ivanov
postmaster [.] _bt_checkkeys On 19 June 2014 15:57, Merlin Moncure wrote: > On Thu, Jun 19, 2014 at 5:12 PM, Borislav Ivanov > wrote: > > However, most people on our team think that the number of connections is > > purely a symptom of the actual problem. We would love to be wrong ab

Re: [GENERAL] Best backup strategy for production systems

2014-06-19 Thread Borislav Ivanov
If your database is relatively small, I would recommend http://www.pgbarman.org/. It does binary backup and will take care of your WAL files. The laster version of pgbarman can also take backups from a slave using pgespresso extension. Note that pgbarman runs over streaming replication protocol. I

Re: [GENERAL] max_connections reached in postgres 9.3.3

2014-06-19 Thread Borislav Ivanov
Hi Ramya, We experience exactly the same problem here at Bitbucket. From what I can tell the major difference between your setup and ours is that you run 9.3.3 and we run 9.2.8. Our post for the issues is at http://www.postgresql.org/message-id/CAJ+wzrb1qhz3xuoeSy5mo8i=E-5OO9Yvm6R+VxLBGaPB=ue...@m