From: Joshua D. Drake <jd@commandprompt.com>
To: Tomeh, Husam <htomeh@firstam.com>
Cc: PgSQL ADMIN <pgsql-admin@postgresql.org>
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Date: Wed, 12 Jan 2005 15:41:41 -0800
Message-ID: <41E5B5B5.6090802@commandprompt.com> (raw)
In-Reply-To: <C45835824D00A844BBD0F032D5CDED9212FBDC@pisgana01sxch01.ana.firstamdata.com>
References: <C45835824D00A844BBD0F032D5CDED9212FBDC@pisgana01sxch01.ana.firstamdata.com>
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?
Create your postgres user
Install Postgres
make sure postgres user owns everything
use postgres user
>
> --
> Husam
> **********************************************************************
> This message contains confidential information intended only for the
> use of the addressee(s) named above and may contain information that
> is legally privileged. If you are not the addressee, or the person
> responsible for delivering it to the addressee, you are hereby
> notified that reading, disseminating, distributing or copying this
> message is strictly prohibited. If you have received this message by
> mistake, please immediately notify us by replying to the message and
> delete the original message immediately thereafter.
>
> Thank you. FADLD Tag
> **********************************************************************
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Command Prompt, Inc., your source for PostgreSQL replication,
professional support, programming, managed services, shared
and dedicated hosting. Home of the Open Source Projects plPHP,
plPerlNG, pgManage, and pgPHPtoolkit.
Contact us now at: +1-503-667-4564 - http://www.commandprompt.comAttachments:jd.vcf (text/x-vcard, 638B) download
begin:vcard
fn:Joshua D. Drake
n:Drake;Joshua D.
org:Command Prompt, Inc.
adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA
email;internet:jd@commandprompt.com
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl.
x-mozilla-html:FALSE
url:http://www.commandprompt.com/
version:2.1
end:vcard
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, htomeh@firstam.com
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
In-Reply-To: <41E5B5B5.6090802@commandprompt.com>
References: <C45835824D00A844BBD0F032D5CDED9212FBDC@pisgana01sxch01.ana.firstamdata.com> <41E5B5B5.6090802@commandprompt.com>
* 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