Data cluster initialization on NFS for different databases.

--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  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.
ear=3D"all">Frederiko



--001636e0b3568b75d40485de507b--