moving tables

From: "Midge Brown" <midgems(at)sbcglobal(dot)net>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: moving tables
Date: 2012-06-20 22:27:25
Message-ID: CF4C3D2E11EC45D59CE287E81AFCE3F5@BERNICE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

ANY comments, suggestions, or direction to existing documentation would be greatly appreciated.

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2012-06-21 00:28:38 Re: moving tables
Previous Message philippe.beaudoin 2012-06-20 19:51:38 random char or text variable in pgbench