X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 12B5E8B9B2C for ; Sat, 12 Feb 2005 16:18:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79872-05 for ; Sat, 12 Feb 2005 16:18:53 +0000 (GMT) Received: from out005.verizon.net (out005pub.verizon.net [206.46.170.143]) by svr1.postgresql.org (Postfix) with ESMTP id 04B478B9E85 for ; Sat, 12 Feb 2005 16:18:52 +0000 (GMT) Received: from jfradkin ([66.15.127.235]) by out005.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050212161851.HWKN6130.out005.verizon.net@jfradkin> for ; Sat, 12 Feb 2005 10:18:51 -0600 From: "Joel Fradkin" To: Subject: Setting up data on two drives newb version. left off a little info on memory if you change the shared buffers. Date: Sat, 12 Feb 2005 11:22:28 -0500 Message-ID: <000001c5111f$0c995180$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Authentication-Info: Submitted using SMTP AUTH at out005.verizon.net from [66.15.127.235] at Sat, 12 Feb 2005 10:18:50 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.179 tagged_above=0 required=5 tests=AWL, MSGID_DOLLARS X-Spam-Level: *** X-Archive-Number: 200502/104 X-Sequence-Number: 16272 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 /proc/sys/kernel/shmmax to make it permanent edit /etc/sysctl.conf kernel.shmmax =3D example shared_buffers =3D 20000 it is 167763968 (160mb). Joel Fradkin =A0