Re: Setting up streaming replication w/ a big ole database

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: Setting up streaming replication w/ a big ole database
Дата
Msg-id CAOC+FBUeAUw5J7EUzJH2-RyZUGxAJCXpcDJ5C=G-3n_hS0+B2g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Setting up streaming replication w/ a big ole database  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Setting up streaming replication w/ a big ole database  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Setting up streaming replication w/ a big ole database  (Robert Burgholzer <rburghol@vt.edu>)
Список pgsql-admin
Дерево обсуждения
I admit to being scared as crap of rsync'ing a live database to another server. Like chills are running down my spine even typing it. Is this an approved, safe thing?

On Tue, Apr 10, 2012 at 11:38 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Tue, Apr 10, 2012 at 12:34 PM, Wells Oliver <wellsoliver@gmail.com> wrote:
> Hey all, I have a question about streaming replication available in PG 9+
>
> The general configuration I see is along the lines of this:
>
> http://brandonkonkle.com/blog/2010/oct/20/postgres-9-streaming-replication-and-django-balanc/
>
> Where you do the file system backup and restore. However, our current server
> I wish to make master has a 75GB database. I can't take the server down, and
> I can't run rsync against the live DB.

You don't need to take the master down.  But you do need to run rsync.
 Note that rsync has a --bwlimit flag to reduce its impact on the
master.



--
Wells Oliver
wellsoliver@gmail.com

В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Setting up streaming replication w/ a big ole database
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Setting up streaming replication w/ a big ole database