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