Skip site navigation (1) Skip section navigation (2)

Re: Multiple logical databases

From: "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
To: "Rick Gigger" <rick(at)alpinenetworking(dot)com>
Cc: "Chris Campbell" <chris(at)bignerdranch(dot)com>, "Mark Woodward" <pgsql(at)mohawksoft(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Multiple logical databases
Date: 2006-02-03 20:28:54
Message-ID: 16578.24.91.171.78.1138998534.squirrel@mail.mohawksoft.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
>
> 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?"



In response to

Responses

pgsql-hackers by date

Next:From: Mark DilgerDate: 2006-02-03 21:01:01
Subject: Re: Function Stats WAS: Passing arguments to views
Previous:From: Mark WoodwardDate: 2006-02-03 20:26:29
Subject: Re: Multiple logical databases

pgsql-patches by date

Next:From: Tom LaneDate: 2006-02-03 21:15:32
Subject: Re: psql tab completion enhancements
Previous:From: Joachim WielandDate: 2006-02-03 20:26:48
Subject: Re: psql tab completion enhancements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group