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

From: "Joel Fradkin" <jfradkin(at)wazagua(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Setting up data on two drives newb version. left off a little info on memory if you change the shared buffers.
Date: 2005-02-12 16:22:28
Message-ID: 000001c5111f$0c995180$797ba8c0@jfradkin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
 

Browse pgsql-admin by date

  From Date Subject
Next Message John Jensen 2005-02-12 17:54:28 Re: Setting up data on two drives newb version. left
Previous Message Joel Fradkin 2005-02-12 15:56:08 Setting up data on two drives newb version.