From: Ben Kim <bkim@tamu.edu>
To: pgsql-admin@postgresql.org
Subject: linux standard layout
Date: Mon, 8 Mar 2010 23:31:40 -0600 (CST)
Message-ID: <Pine.GSO.4.64.1003082243200.10671@coe.tamu.edu> (raw)
Dear list,
I have about 20 postgresql databases, about 3-4 GB in total.
We are moving them from Solaris/SPARC to a linux based virtual machine.
I don't like the VMWare environment, but it's not my choice, and assuming
the cpu load is ok, will there be any benefits if I put each database on
separate partitions, vs. simply using the one data directory?
Also, how is using standard rpm, with its standard layout (/var/lib/pgsql,
/usr/lib/pgsql, ...), generally regarded? ( vs. compiling everything ?)
Does anyone think using the rpm is unprofessional or something that only
beginners will do?
I have someone who opposes the use of standard rpms (even yums) for this
reason. I thought I'd check out how it is received professionally.
I ask the question because sometimes I feel uneasy mixing rpms and source
compilation.
If I compile something from the source, sometimes I see a boundary
condition - like, if I already have DBI from a standard rpm, it expects
postgresql library at a certain location - making me wonder whether I
should remove the DBI rpm and compile it also from the source, or whether
I should use standard rpms for postgresql as well. (DBI may not be a good
example.)
In general I didn't have any problems yet with standard rpms and I can
make the rpms work if there's a problem, but I may be missing something.
Any advice or reference to a relevant article on this issue will be
appreciated.
Thanks.
Ben Kim
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bkim@tamu.edu
Subject: Re: linux standard layout
In-Reply-To: <Pine.GSO.4.64.1003082243200.10671@coe.tamu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox