Re: basic questions: Postgres with yum on CentOS 5.1 - Mailing list pgsql-general

From Greg Smith
Subject Re: basic questions: Postgres with yum on CentOS 5.1
Date
Msg-id Pine.GSO.4.64.0801012351410.29005@westnet.com
Whole thread Raw
In response to Re: basic questions: Postgres with yum on CentOS 5.1  (Chuck <chuckr@velofish.com>)
Responses Re: basic questions: Postgres with yum on CentOS 5.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, 1 Jan 2008, Chuck wrote:

> Since I have a packaged installation, I don't believe that I will call
> initdb directly.

There is actually another command I don't think you've noticed yet:

service postgresql initdb

That runs initdb with the user and permissions properly to get you
something the serivce can start and stop.  If you start the service
without an initialized database as you do in your example, it will run
that initdb task for you.

I'd suggest taking a look at the init script in
/etc/rc.d/init.d/postgresql for a bit to see what those commands are
actually doing under the hood.  The initdb one may not be useful for
you--the --auth settings may not be what you want for example, and there's
the language question as well.  But seeing exactly what the stock initdb
does should be instructive.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: basic questions: Postgres with yum on CentOS 5.1
Next
From: Richard Broersma Jr
Date:
Subject: visibility rules for AFTER UPDATE Constraint Triggers Function