Setting up data on two drives newb version. left off a little info on memory if you change the shared buffers.

Поиск
Список
Период
Сортировка
От Joel Fradkin
Тема Setting up data on two drives newb version. left off a little info on memory if you change the shared buffers.
Дата
Msg-id 000001c5111f$0c995180$797ba8c0@jfradkin
обсуждение исходный текст
Список pgsql-admin
This was also in the Desknow web page.

changing these parameters will probably cause postgres to not start.
su - postgres
pg_ctl -D /var/lib/pgsql/data start ( I actualy left the path off )
in the message it says you need to increase SHMMAX to a certain number.

To do this you must be root
echo <shared_buffers * 8192> /proc/sys/kernel/shmmax

to make it permanent
edit /etc/sysctl.conf
kernel.shmmax = <shared_buffers * 8192>

example shared_buffers = 20000 it is 167763968 (160mb).



Joel Fradkin
 



В списке pgsql-admin по дате отправления:

Предыдущее
От: "Joel Fradkin"
Дата:
Сообщение: Setting up data on two drives newb version.
Следующее
От: "John Jensen"
Дата:
Сообщение: Re: Setting up data on two drives newb version. left