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

From Joel Fradkin
Subject Setting up data on two drives newb version. left off a little info on memory if you change the shared buffers.
Date
Msg-id 000001c5111f$0c995180$797ba8c0@jfradkin
Whole thread Raw
List 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 by date:

Previous
From: "Joel Fradkin"
Date:
Subject: Setting up data on two drives newb version.
Next
From: "John Jensen"
Date:
Subject: Re: Setting up data on two drives newb version. left