Thread: maximum number of connections.

Does anyone know how to make one DB available to more than one port with
the postmaster. For instance port 5432 and port 5431 are both foo db. Is
postgres limited to a maximum number of connections and if so what is
the maximum number? i've got some documentation but I can't seem to find
anything on this (maybe its me =)). Is there any information on this
somewhere?

cheers people

another naff question brought to you by  Stuart 


+-=-=-=-=-=-=-=-=-=-StOo-=-=-=-=-=-=-=-=-=-+

Stuart Hodgkinson Software Engineer

Stuart@comodo.net


We're sorry, the person you're calling is dead!

StOo <stuart@comodo.net> writes:
> Does anyone know how to make one DB available to more than one port with
> the postmaster. For instance port 5432 and port 5431 are both foo db.

Can't be done AFAIK.  Why would you want to, anyway?

> Is postgres limited to a maximum number of connections and if so what
> is the maximum number?

See FAQ regarding max number of backends.
        regards, tom lane