Re: [GENERAL] [ADMIN] Cannot start the PostgreSQL service

2016-01-30 Thread John Scalia
The settings in you pg_hba.conf aren't really correct. The second line won't work at all. The max value after the "/" is 32. This is not for the port number. You might wish to search setting a CIDR value, but if you want to allow: Just 192.168.1.1 then host all all 192.

Re: [GENERAL] [ADMIN] How Many PG_Locks are considered too many

2015-07-30 Thread John Scalia
Seconding Peter on this one; it's a lot more important should one of those locks be hanging around, say for hours or days, not how many have come and gone. -- Jay On Thu, Jul 30, 2015 at 8:57 AM, Renato Oliveira < renato.olive...@cantabcapital.com> wrote: > Peter thank you much appreciated > > Se