pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: Moving database install to new SAN
Date: Thu, 13 Sep 2007 22:39:46 +0200
Message-ID: <20070913203946.GE6423@easy2.in-chemnitz.de> (raw)
In-Reply-To: <507905.14268.qm@web57114.mail.re3.yahoo.com>
References: <507905.14268.qm@web57114.mail.re3.yahoo.com>

On Thu, Sep 13, 2007 at 01:15:34PM -0700, Abu Mushayeed wrote:

>   Can someone help me with moving a postgres database install to a new
>   SAN disks. We are getting a new set of faster disk, I would like to
>   find out is there a way, without reinstall to move existing database
>   and data to the new disks with minimal downtime.

If you cannot move online with some SAN tools, you may simply

1. stop postgres
2. copy whole data directory over to new SAN
3. start postgres with new data directory

Nothing tricky there.

What size is you db space? What OS are you running PostgreSQL on?

Tino.

-- 
www.spiritualdesign-chemnitz.de
www.lebensraum11.de

Tino Schwarze * Parkstraße 17h * 09120 Chemnitz



view thread (6+ messages)  latest in thread

Message-ID: <20070913203946.GE6423@easy2.in-chemnitz.de>
Permalink:  ../20070913203946.GE6423@easy2.in-chemnitz.de/
Also on:    postgresql.org/message-id/20070913203946.GE6423@easy2.in-chemnitz.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: postgresql@tisc.de
  Subject: Re: Moving database install to new SAN
  In-Reply-To: <20070913203946.GE6423@easy2.in-chemnitz.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox