Darcy Buskermolen wrote:
On January 12, 2005 04:31 pm, Joshua D. Drake wrote:
Peter Eisentraut wrote:
Tomeh, Husam wrote:
I've seen book that prefer installing PostgreSQL as root and another
one recommends otherwise by first creating a postgres account and
then installing it as postgres. In the Oracle world, you don't use
root to install the software. What is the best practice as far as
PostgreSQL goes?
The current recommendation, which is reflected in the installation
instructions, is to install the software as root and to use the
postgres user for the database files. The advice seen elsewhere in
this thread to use the postgres user also for the software files is
wrong.
If the user owns the catalog, there is no reason for that user to not
also own the files.
Sincerely,
Joshua D. Drake
Isn't there a requiremnet of writing libpq.so to a location that ldconfig can
make use of it? By default FreeBSD won't let you ldconfig a file that isn't
owned by root (or that is in a directory that is writeable by anybody other
than members of group 0).
Now that is interesting. That is not a problem on Linux. I didn't
know that FreeBSD was like that.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
x-mozilla-html:FALSE
url:http://www.commandprompt.com
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
