Re: Solutions for listening on multiple ports?

On 10/9/07, Jason L. Buberel <jason(at)buberel(dot)org> wrote:
>
> Is there a 'generally accepted' best practice for enabling a single
> postgres instance to listen for client connections on more than one ip/port
> combination?
>
> As far as I can tell, the 'listen_address' and 'port' configuration
> variables can only accommodate single values:
>
> listen_address = 127.0.0.1
> port = 5432

As mentioned by someone else, you can have > 1 IP be listended to, but
only the one port. You could likely use port forwarding to accomplish
having pgsql listen on > 1 port. In linux you'd do this with
iptables.