Thaks Stefan On 13 jul, 12:25, ste...@xxxxxxxxxxxxxxxx (Stefan Kaltenbrunner) wrote: > tabai wrote: > > Hi > > > I know that i can limited the total number of connections in > > postgresql.conf with max_connections, but... can i limite the max > > number of connections from an specific IP? > > > For example y like have total max connections of 40 buy the same ip > > can't have more than 5 connections open. > > > It is possible? > > no - you can limit the maximum numbers of connections on a per database > and also a per role base. If you really need a per source address > limitation look into using whatever firewall solution is available on > your OS. > > Stefan > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match
