Postgres Pro
Downloads
Home   >   mailing lists

Re: [general] rsync'd database requires reindex - why ? - Mailing list pgsql-general

From Simon Riggs
Subject Re: [general] rsync'd database requires reindex - why ?
Date
Msg-id CA+U5nMLN4s_FLHp7Y-2FbVh=OCbSf_6v7g-kdP3uZXNZHsNzow@mail.gmail.com
Whole thread Raw
In response to [general] rsync'd database requires reindex - why ?  (marcin kowalski <yoshi314@gmail.com>)
List pgsql-general
Tree view 
On Tue, Nov 22, 2011 at 7:32 AM, marcin kowalski <yoshi314@gmail.com> wrote:

> i'm simply stopping postgresql

If you do do pg_ctl stop -m immediate then the copy will be corrupt.

You need to do a correct shutdown for it to work.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Using KNN for objects that have more than 2 dimensions?
Next
From: Simon Riggs
Date:
Subject: Re: VACUUM touching file but not updating relation