Re: basic questions: Postgres with yum on CentOS 5.1

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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD