pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Hoover <revoohc@gmail.com>
To: Andrzej Zawadzki <zawadaa@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Moving database install to new SAN
Date: Thu, 20 Sep 2007 14:10:11 -0400
Message-ID: <1d219a6f0709201110r603e1d4dg8cc4f514201a65ab@mail.gmail.com> (raw)
In-Reply-To: <46E9A81D.90309@gmail.com>
References: <507905.14268.qm@web57114.mail.re3.yahoo.com>
	<20070913203946.GE6423@easy2.in-chemnitz.de>
	<46E9A81D.90309@gmail.com>

>
> > 2. copy whole data directory over to new SAN
> If database is big, then I think that is much faster to copy running
> database
> to new SAN.
> Then stop postgres and rsync what was changed - but this will be probably
> only a few files.



I believe if you do this, you will not get a function database in the end.
There is a lot of data that is held in memory/buffers that may not be
flushed to the disks.  You have no guarantee you will get this data with
this method.

Either shut the database down and cold copy it, or setup replication using
Slony to move the data in a "hot"mode.

HTH,

Chris

view thread (6+ messages)  latest in thread

Message-ID: <1d219a6f0709201110r603e1d4dg8cc4f514201a65ab@mail.gmail.com>
Permalink:  ../1d219a6f0709201110r603e1d4dg8cc4f514201a65ab@mail.gmail.com/
Also on:    postgresql.org/message-id/1d219a6f0709201110r603e1d4dg8cc4f514201a65ab@mail.gmail.com

 · 

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: revoohc@gmail.com, zawadaa@gmail.com
  Subject: Re: Moving database install to new SAN
  In-Reply-To: <1d219a6f0709201110r603e1d4dg8cc4f514201a65ab@mail.gmail.com>

* 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