Re: Listening on more than one port?

From: Shane Ambler <pgsql(at)007Marketing(dot)com>
To: PostgreSQL Mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Listening on more than one port?
Date: 2006-08-31 15:26:34
Message-ID: C11D35C2.4BCE7%pgsql@007Marketing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Obviously the test section has separate configurations to the live section -
simply have 2 databases defined in the same server 'ourlivedatabase' and
'ourtestdatabase'. This still gives one small login/config setting that
changes between live and dev.

On 31/8/2006 12:20, "Kelly Burkhart" <kelly(at)kkcsm(dot)net> wrote:

> On 8/30/06, Michael Nolan <htfoot(at)gmail(dot)com> wrote:
>> Situation in a nutshell:
>>
>> Production and test databases are on two separate systems inside the
>> firewall. The web server is at an ISP, outside the firewall.
>>
>> The firewall sends all data coming from the ISP, port 5432 to a specific IP
>> address inside the firewall: port 5432, which is the production serve.
>>
>> Test transactions need to go to the other server, which has to be the same
>> IP address (the address of the firewall), so it needs to be a different
>> port, but I'm not sure if the port translator in the firewall will do any
>> better at getting a response that than a port translator on the test server
>> does.
>>
>> However, I also need the test database responding to requests on port 5432.
>
> Your firewall can probably redirect firewallhost:5431 to
> insidehost:5432. If not, you could use something like simpleproxy on
> insidehost to do what you want.
>
> <http://sourceforge.net/projects/simpleproxy/>
>
> -K
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--

Shane Ambler
Postgres(at)007Marketing(dot)com

Get Sheeky @ http://Sheeky.Biz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2006-08-31 15:34:44 Re: Strange error related to temporary tables
Previous Message Alban Hertroys 2006-08-31 15:25:56 Re: Strange error related to temporary tables