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 CD4858B9B50 for ; Sat, 12 Feb 2005 15:52:33 +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 76827-04 for ; Sat, 12 Feb 2005 15:52:31 +0000 (GMT) Received: from out008.verizon.net (out008pub.verizon.net [206.46.170.108]) by svr1.postgresql.org (Postfix) with ESMTP id 610DD8B9B2B for ; Sat, 12 Feb 2005 15:52:30 +0000 (GMT) Received: from jfradkin ([66.15.127.235]) by out008.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050212155230.VTEE9672.out008.verizon.net@jfradkin> for ; Sat, 12 Feb 2005 09:52:30 -0600 From: "Joel Fradkin" To: Subject: Setting up data on two drives newb version. Date: Sat, 12 Feb 2005 10:56:08 -0500 Message-ID: <000001c5111b$5e95c530$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 out008.verizon.net from [66.15.127.235] at Sat, 12 Feb 2005 09:52:30 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.181 tagged_above=0 required=5 tests=AWL, MSGID_DOLLARS X-Spam-Level: *** X-Archive-Number: 200502/103 X-Sequence-Number: 16271 I just wanted to thank everyone who jumped in to help me. Hopefully I have it set up ok. Postgres install using more then one raid array for drives. Install Postgres (I did not let the OS install it as I was wanting to = use 8 and Fedora Core 3 was shipping with 7.4) After I installed Fedora, I went to : http://www.postgresql.org/=20 Downloads off main menu FTP browser link Binary link 8.0 Linux rpms fedora fedora-core-3 http://www.postgresql.org/ftp/binary/v8.0/linux/rpms/fedora/fedora-core-3= / I was able to pull all the rpms (it did ask for the cd for fedora a few times). Once that is completed, you should be able to pull up the start services = and see pgsql as a service. If you start it it will create a /var/lib/pgsql/lib/data folder. Data is = the initdb folder. When you run initdb it creates this folder for you inside whatever = folder you are running intdb for. What I did (I have a machine where I set up two additional raid arrays = for the data and the wal files; I was told it is best to use raid 10, 10k drives for the data and raid = 1 15k drives for the wa/) was initdb /pgsql. pgsql is what I called my raid 10 array and /wal is what I called my 15k raid 1 array. This creates a data folder in /pgsql. in /var/lib/pgsql/data I edited the pgsql.config and changed to data_directory =3D '/pgdata/data'. I also:=20 listen_addresses =3D '*' shared_buffers =3D 4000 max_fsm_pages =3D 30000 # min max_fsm_relations*16, 6 bytes each max_fsm_relations =3D 1000 # min 100, ~50 bytes each effective_cache_size =3D 40000 # typically 8KB each (my box is 8 gig so = I may edit this) These settings I got from looking at http://www.desknow.com/kb/idx/0/061/article/ It said to do a vacuum verbose total pages should be lower the max_fsm_pages. in pg_hba.conf I added host all all 192.168.123.121 255.255.255.0 = trust to allow me to connect from my desktop. Before starting the system up a second time (after adding the data_directory) I went in to the /pgsql/data folder and (A fellow from the mailing list helped me here to relocate the wal) 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. only diference was I am not using $PGDATA I am using the directory = command in conf. So I chabged dir to /pgsql/data. WHen I started postgres I could see data growing on both the /wal and = /pgsql drives. I am still not 100% sure that just the data is on /pgsql/data, but at = least it is using a different drive then the OS=20 and the wal and data are on different drives.=A0