Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 1AC2763317A for ; Wed, 5 May 2010 17:03:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 41414-07 for ; Wed, 5 May 2010 20:03:09 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com [74.125.83.174]) by mail.postgresql.org (Postfix) with ESMTP id 5908C6322B9 for ; Wed, 5 May 2010 17:03:09 -0300 (ADT) Received: by pva18 with SMTP id 18so679048pva.19 for ; Wed, 05 May 2010 13:03:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:from:date :message-id:subject:to:content-type; bh=Lke0udRlaSw2H+Jd4dAjXNXAlKzm4t16iWluPdjo6l0=; b=es8+s+VkQD+RgtcwKeN7IP7KIHCmrGkjGsNr8PQ88n4RgbIhFuDXwvMXwPrtpeOdG0 qcc6wFOKqJ1JKWjR/OWgInnQKnXYE3h9oFrRen4yACBMdT8k+9RTzcuHBeJGaYvvYPTd /TiLSxQ/RlCvzRMZemclJWW98C8nhZsOe2w3s= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:from:date:message-id:subject:to:content-type; b=aibRs9obd3Hid/oHFLeDBmFA/Z3s9rxVLnfFj7+3Ik787u+QvXVR2gWaJH0/ew7ksV 9yb6FrovwVGUuy+r9IGla4ns/cIRLEB61jQgPuvq/YsxDwdvGEbXwd0deP7cy7+yPxtn clwevPA7Qwy0ltJYTGi3CG9remWcxZ9Lo9ANk= Received: by 10.143.153.24 with SMTP id f24mr4432763wfo.292.1273089787393; Wed, 05 May 2010 13:03:07 -0700 (PDT) MIME-Version: 1.0 Received: by 10.142.240.6 with HTTP; Wed, 5 May 2010 13:02:47 -0700 (PDT) From: Frederiko Costa Date: Wed, 5 May 2010 13:02:47 -0700 Message-ID: Subject: Data cluster initialization on NFS for different databases. To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=001636e0b3568b75d40485de507b X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201005/76 X-Sequence-Number: 34549 --001636e0b3568b75d40485de507b Content-Type: text/plain; charset=UTF-8 Hello, I've got a few questions in regards to the way I'd like to design my database area. Currently I have 2 projects. These projects contain two dedicated databases, but their data would be stored in the same NFS server. What I have as a plan is to run two different instances of pgsql server on these two separate machines and save the data on two different directories - acting as database area - exported via NFS. I believe to gain a little bit flexibility later in case I decide one database to a different place. But I don't think this would be decision making approach. The question is if this approach is what most people do? I was also thinking that if the number of projects grows, this could become a potential headache to manage. Would be possible to have a single directory - containing the database area - exported and shared by different hosts, reading and writing on different databases? If yes, is it recommended? The last question is if NFS would be a good option as network, does anybody recommend another network file system? Thanks in advance. Frederiko --001636e0b3568b75d40485de507b Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello,

I've got a few questions in regards to the way I'd li= ke to design my database area. Currently I have 2 projects. These projects = contain=C2=A0 two dedicated databases, but their data would be stored in th= e same NFS server. What I have as a plan is to run two different instances = of pgsql server on these two separate machines and save the data on two dif= ferent directories - acting as database area - exported via NFS. I believe = to gain a little bit flexibility later in case I decide one database to a d= ifferent place. But I don't think this would be decision making approac= h.

The question is if this approach is what most people do? I was also thi= nking that if the number of projects grows, this could become a potential h= eadache to manage.

Would be possible to have a single directory - c= ontaining the database area - exported and shared by different hosts, readi= ng and writing on different databases? If yes, is it recommended?

The last question is if NFS would be a good option as network, does any= body recommend another network file system?

Thanks in advance.
Frederiko

--001636e0b3568b75d40485de507b--