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 4BE768B9FE7 for ; Thu, 10 Feb 2005 20:29:30 +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 96539-10 for ; Thu, 10 Feb 2005 20:29:06 +0000 (GMT) Received: from out004.verizon.net (out004pub.verizon.net [206.46.170.142]) by svr1.postgresql.org (Postfix) with ESMTP id E04128B9EC3 for ; Thu, 10 Feb 2005 20:29:07 +0000 (GMT) Received: from jfradkin ([66.15.127.235]) by out004.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050210202905.ZGEP15146.out004.verizon.net@jfradkin> for ; Thu, 10 Feb 2005 14:29:05 -0600 From: "Joel Fradkin" To: Subject: Installing 8 using a different drive for data Date: Thu, 10 Feb 2005 15:32:39 -0500 Message-ID: <001201c50faf$ac0cf170$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 out004.verizon.net from [66.15.127.235] at Thu, 10 Feb 2005 14:29:04 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.186 tagged_above=0 required=5 tests=AWL, MSGID_DOLLARS X-Spam-Level: *** X-Archive-Number: 200502/88 X-Sequence-Number: 16256 I tried changing the directory in postgres.conf, but it is looking for a PG_VERSION? Do I need to do a dbinti or something? I only want my data to be in the pgdata drive I want the rest in /var/lib/pgsql/data I actually want my wal in /wal (a different drive as well). I have the instructions 0) backup your data 1) stop postmaster and verify. 2) cd $PGDATA; mv pg_xlog original_pg_xlog; ln -s /wal pg_xlog; cp=20 original_pg_xlog/* pg_xlog 3) start postmaster and confirm correct startup in log files. Does this look like it will work for 8, do I do it from the /pgdata = folder once II get that working or from /var/lib/pgsql/data? Joel Fradkin =A0 Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel.=A0 941-753-7111 ext 305 =A0 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. =A9 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA,=A0Inc =A0This email message is for the use of the intended recipient(s) and = may contain confidential and privileged information.=A0 Any unauthorized = review, use, disclosure or distribution is prohibited.=A0 If you are not the = intended recipient, please contact the sender by reply email and delete and = destroy all copies of the original message, including attachments. =A0 =A0