Re: Multiple logical databases - Mailing list pgsql-hackers

From Mark Woodward
Subject Re: Multiple logical databases
Date
Msg-id 16578.24.91.171.78.1138998534.squirrel@mail.mohawksoft.com
Whole thread Raw
In response to Re: Multiple logical databases  (Rick Gigger <rick@alpinenetworking.com>)
Responses Re: Multiple logical databases
List pgsql-hackers
>
> On Feb 3, 2006, at 6:47 AM, Chris Campbell wrote:
>
>> On Feb 3, 2006, at 08:05, Mark Woodward wrote:
>>
>>> Using the "/etc/hosts" file or DNS to maintain host locations for
>>> is a
>>> fairly common and well known practice, but there is no such
>>> mechanism for
>>> "ports." The problem now becomes a code issue, not a system
>>> administration
>>> issue.
>>
>> What if you assigned multiple IPs to a machine, then used ipfw (or
>> something) to forward connections to port 5432 for each IP to the
>> proper IP and port?
>
> If he had multiple ips couldn't he just make them all listen only on
> one specific ip (instead of '*') and just use the default port?

That is a good idea, and yes it would work, as do a lot of other
scenarios, but shouldn't PostgreSQL take care of "PostgreSQL?"




pgsql-hackers by date:

Previous
From: "Mark Woodward"
Date:
Subject: Re: Multiple logical databases
Next
From: Mark Dilger
Date:
Subject: Re: Function Stats WAS: Passing arguments to views