setting redshift connection limits for local users

Actually quite easy with:

alter user connection limit <max number of connections desired> | unlimited;

Note: some tools require at least two connections just to make one query – e.g. SQLWorkBench.