Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id AEF6A1975915 for ; Wed, 20 Jun 2012 19:27:42 -0300 (ADT) Received: from nm29-vm0.access.bullet.mail.mud.yahoo.com ([66.94.236.255]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1ShTNF-0005ub-DR for pgsql-performance@postgresql.org; Wed, 20 Jun 2012 22:27:42 +0000 Received: from [66.94.237.200] by nm29.access.bullet.mail.mud.yahoo.com with NNFMP; 20 Jun 2012 22:27:28 -0000 Received: from [98.139.221.48] by tm11.access.bullet.mail.mud.yahoo.com with NNFMP; 20 Jun 2012 22:27:28 -0000 Received: from [127.0.0.1] by smtp101.sbc.mail.bf1.yahoo.com with NNFMP; 20 Jun 2012 22:27:28 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sbcglobal.net; s=s1024; t=1340231248; bh=8sDEFiqAaWwjfpsuAZWAPV8pryQSoVNrnGn5vNjb7oc=; h=X-Yahoo-Newman-Id:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:Message-ID:From:To:Subject:Date:MIME-Version:Content-Type:X-Priority:X-MSMail-Priority:X-Mailer:X-MimeOLE; b=JmhYQrdNHdGvwuVPjszrdvRHs5EHfhe5BQhVMo6ksGBY8YysfvDOiASD1D9xWe5eeUinr2atsaHgR4G5aB6Lo4wCD1XUOimMGWpyy/I81H2kAU1wQveWKZaCY6pNEb7NwC5V2QbE+zgDdLUVuforJ7STX4R0fs1U5jNeUZmNHz4= X-Yahoo-Newman-Id: 399399.71414.bm@smtp101.sbc.mail.bf1.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: oQ7E7d0VM1lGTudPbgPIHcJ0c0yNDuB5fssE0kNsC7UHCUh 0Ppn_JXHdbisxu7JuCT.yjNPMvBAlux6mUVoWfap3aMDAXErY34FFMGl.5pY wsUODbM5QZje.SU7cT4BaOVwt1V3dlaSvOLeSK5mC.4UHl9YZT6kvxRtxd7m 01dcTfgc1Gk7m8P6pcsF17QZ9Xt0VrOGDzEBZ6AjECsGuSAGv1b3ZNe9TD3f kMVtf9xWaVLy_CdUSzBz7RAXEG5gGMQti_7QTA.e0IDDzu7J9taTJPmQ8Y7F SF.r._Eib5zPSP4TMNy.RzpZng2XnSqZgnbVqsHhMNsjMZyFzGp7UVJdQF2r Qb3KAXqufsIAji3nV.3W_6fKh9U5TWB5UZn0O60ArTpUen_nsrxemTpaJyjr eRnztqXjrxHAhwhW22AIMF1L5Ecjie4IYluYelZF7wn8LEDW4mxM6wAyGswy mCFIDaIyQeGCW5oQ- X-Yahoo-SMTP: EtaTb4uswBBSx2FARGS8Y34d19mAO_hWIqN6lfRu55otbg-- Received: from BERNICE (midgems@71.135.41.227 with login) by smtp101.sbc.mail.bf1.yahoo.com with SMTP; 20 Jun 2012 15:27:27 -0700 PDT Message-ID: From: "Midge Brown" To: Subject: moving tables Date: Wed, 20 Jun 2012 15:27:25 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0A74_01CD4EF9.31A23670" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 X-Pg-Spam-Score: 0.8 (/) X-Archive-Number: 201206/113 X-Sequence-Number: 47139 This is a multi-part message in MIME format. ------=_NextPart_000_0A74_01CD4EF9.31A23670 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I need to move a postgres 9.0 database -- with tables, indexes, and wals = associated with 16 tablespaces on 12 logical drives -- to an existing = raid 10 drive in another volume on the same server. Once I get the data = off the initial 12 drives they will be reconfigured, at which point I'll = need to move everything from the 2nd volume to the aforementioned 12 = logical drives on the first volume. This is being done both to free up = the 2nd volume and to better utilize raid 10. I checked around and found a way to create sql statements to alter the = public tablespaces and indexes, but I haven't found anything that = provides information about moving the numerous associated config files, = log files, etc.=20 ANY comments, suggestions, or direction to existing documentation would = be greatly appreciated.=20 Current server info: - 4 dual-core AMD Opteron 2212 processors, 2010.485 MHz - 64GB RAM - 16 67GB RAID 1 drives and 1 464GB RAID 10 drive (all ext3) on 2 = volumes. - Linux 2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT 2009 x86_64 x86_64 = x86_64 GNU/Linux Thank you, Midge ------=_NextPart_000_0A74_01CD4EF9.31A23670 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I need to move a postgres 9.0 = database=20 -- with tables, indexes, and wals associated with 16 = tablespaces on 12=20 logical drives -- to an existing raid 10 drive in another volume on = the=20 same server. Once I get the data off the initial 12 drives they = will be=20 reconfigured, at which point I'll need to move everything from the 2nd = volume to=20 the aforementioned 12 logical drives on the first volume. This is being = done=20 both to free up the 2nd volume and to better utilize raid = 10.
 
I checked around and found a way = to create=20 sql statements to alter the public tablespaces and indexes, but I = haven't found=20 anything that provides information about moving the numerous associated = config=20 files, log files, etc.
 
ANY comments, suggestions, or = direction to=20 existing documentation would be greatly = appreciated. 
 
Current server info:
 
- 4 dual-core AMD Opteron 2212 = processors,=20 2010.485 MHz
- 64GB RAM
- 16 67GB RAID 1 drives and 1 = 464GB RAID 10=20 drive (all ext3) on 2 volumes.
- Linux 2.6.18-164.el5 #1 SMP Thu Sep = 3 03:28:30=20 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
 
 
Thank you,
Midge
 
 
 
 
------=_NextPart_000_0A74_01CD4EF9.31A23670--