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
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 |