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

Re: run httpd and postgresql on different machines ?

From: Christian Fowler <spider(at)viovio(dot)com>
To: Chuming Chen <chen(at)musc(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: run httpd and postgresql on different machines ?
Date: 2005-01-18 14:33:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
One machine to run httpd + php and a separate machine for postgres is very 
common and highly recommended.

For safety, I would recommend using a private network (192.168.0.*) to 
connect the two machines, so your DB machine does not even have a public 
IP address. Ideally, use gigabit between the two machines.

Be sure you configure your pg_hba.conf properly too.

On Tue, 18 Jan 2005, Chuming Chen wrote:

> Hi, all,
> I want to set up a web site using apache httpd, php and postgresql. From the 
> performance point of view, which  architecture is better? 1)  Run httpd and 
> postgresql on the same machine; 2) Run postgresql on seperate machine. My 
> concern is that the machine I am going to run httpd has limitted storage. I 
> am expecting the increasing of postgresql database once I set it ip.
> Any suggestions and comments will be highly appreciated.
> -- 
> Chuming Chen
> System Administrator
> NHLBI Proteomics Center
> Medical University of South Carolina
> 135 Cannon Street, Suite 303
> Charleston SC 29425
> Tel: 843-792-1555 (O)
> Fax: 843-876-1126
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>     joining column's datatypes do not match

[ \ /
[ >X<   Christian Fowler      | spider AT
[ / \ |

In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2005-01-18 15:30:32
Subject: Re: how to keep the db connection
Previous:From: Chuming ChenDate: 2005-01-18 13:36:34
Subject: run httpd and postgresql on different machines ?

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