Re: basic questions: Postgres with yum on CentOS 5.1

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: basic questions: Postgres with yum on CentOS 5.1
Дата
Msg-id Pine.GSO.4.64.0801012351410.29005@westnet.com
обсуждение исходный текст
Ответ на Re: basic questions: Postgres with yum on CentOS 5.1  (Chuck <chuckr@velofish.com>)
Ответы Re: basic questions: Postgres with yum on CentOS 5.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: basic questions: Postgres with yum on CentOS 5.1
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: visibility rules for AFTER UPDATE Constraint Triggers Function