Josh Berkus wrote: > On 6/20/12 3:27 PM, Midge Brown wrote: >> 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. > 1. back everything up. > > 2. create a bunch of directories on the RAID10 to match the existing > tablespaces (they won't be mounts, but Postgres doesn't care about that). > > 3. shut down postgres > > 4. copy all your files to the new directories > > 5. change your mount points which were in use by the old tablespaces to > symlinks which point at the new diretories > > 6. start postgres back up from the new location Shouldn't you also 7. UPDATE spclocation in pg_tablespace ? Yours, Laurenz Albe -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
