X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E70EB3A1A30 for ; Tue, 18 Jan 2005 14:33:39 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21892-06 for ; Tue, 18 Jan 2005 14:33:28 +0000 (GMT) Received: from leda.steelsun.com (dsl093-240-204.ral1.dsl.speakeasy.net [66.93.240.204]) by svr1.postgresql.org (Postfix) with ESMTP id 0FE1D3A19CE for ; Tue, 18 Jan 2005 14:33:29 +0000 (GMT) Received: from leda.steelsun.com (localhost [127.0.0.1]) by leda.steelsun.com (8.13.1/8.12.8) with ESMTP id j0IEXNHU018801; Tue, 18 Jan 2005 09:33:23 -0500 Received: from localhost (cfowler@localhost) by leda.steelsun.com (8.13.1/8.12.11/Submit) with ESMTP id j0IEXM6P018798; Tue, 18 Jan 2005 09:33:22 -0500 X-Authentication-Warning: leda.steelsun.com: cfowler owned process doing -bs Date: Tue, 18 Jan 2005 09:33:22 -0500 (EST) From: Christian Fowler X-X-Sender: cfowler@leda.steelsun.com To: Chuming Chen Cc: pgsql-admin@postgresql.org Subject: Re: run httpd and postgresql on different machines ? In-Reply-To: <41ED10E2.6030502@musc.edu> Message-ID: References: <41ED10E2.6030502@musc.edu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/189 X-Sequence-Number: 16048 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 viovio.com [ / \ http://www.viovio.com | http://www.tikipro.org