Re: [GENERAL] Listening on more than one port?

I prefer to have my live and test databases on separate systems, if only because each one takes up well over 100 GB of disk space.  Our hardware firewall doesn't support port changes, but I was able to get the rinetd port redirector working to redirect 5431 to 5432 on the test system..  (And it wor

Re: [GENERAL] Listening on more than one port?

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" <[EMAIL

Re: [GENERAL] Listening on more than one port?

"Michael Nolan" <[EMAIL PROTECTED]> writes: > 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 in

Re: [GENERAL] Listening on more than one port?

On 8/30/06, Michael Nolan <[EMAIL PROTECTED]> 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 i

Re: [GENERAL] Listening on more than one port?

If you need to run two separate databases on the same box, each with its own port, then having two clusters would be one way to go. Each cluster has its own postgresql.conf and so each cluster can be (must be, if I'm not mistaken) configured to listen on a separate port. -

Re: [GENERAL] Listening on more than one port?

On 8/30/06, Martijn van Oosterhout wrote: On Wed, Aug 30, 2006 at 02:42:58PM -0500, Michael Nolan wrote:> I need to be able to have postmaster (8.1.2) listen on more than one port,> eg, 5432 and some other port, such as 5431.Why? Situation in a nutshell:Production  and test data

Re: [GENERAL] Listening on more than one port?

On Wed, Aug 30, 2006 at 02:42:58PM -0500, Michael Nolan wrote: > I need to be able to have postmaster (8.1.2) listen on more than one port, > eg, 5432 and some other port, such as 5431. Why? > If I set up a TCP port redirector like rinetd, to forward packets from port > 5431 to port 5432 it appea

[GENERAL] Listening on more than one port?

I need to be able to have postmaster (8.1.2) listen on more than one port, eg, 5432 and some other port, such as 5431.There does not appear to be a way to configure that. You can configure multiple IP addresses, but not multiple ports. If I set up a TCP port redirector like rinetd, to forward packe