Search Postgresql Archives

Re: basic questions: Postgres with yum on CentOS 5.1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux