Re: New Slave - timeline ERROR

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: New Slave - timeline ERROR
Дата
Msg-id CAGrpgQ8+J_X3knvDejHXp8BtHseP2MFQ4TiSQJ1WjjK20tSosg@mail.gmail.com
обсуждение исходный текст
Ответ на New Slave - timeline ERROR  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Ответы Re: New Slave - timeline ERROR  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Список pgsql-general
On Fri, Jan 8, 2016 at 8:44 PM, drum.lucas@gmail.com <drum.lucas@gmail.com> wrote:

Hi, I'm a bit too lazy to try suss out the exact reasons for your failure, but here is a reasonably thorough guide to set up replication:
http://dba.stackexchange.com/a/53546/24393

A few tips:
- Having the master ship WALs to the slaves is handy if you can pull it off. If you are doing it over the wire and using rsync, "-z" for compression is recommended. If you are doing the tar format of the pg_basebackup, you *must* have the master ship the WALs to the slave otherwise it won't be able to synchronize (the "stream" method ships WALs over the wire so the end result is a synchronized system.

- I always run pg_basebackup from the slave I am building, for simplicity.
- I create new slaves almost every day (we have thousands of databases) using a bash script and it almost much never fails. In essence it is a big wrapper around the pg_basebackup command (though we are using pg93 mostly).

The base backup command that I run from the slave I am building:
pg_basebackup --pgdata=$PGDATA --host=$MASTER_IP --port=$PGPORT --username=replication --no-password --xlog-method=stream --format=plain --progress --verbose

The recovery.conf:
standby_mode = 'on'
primary_conninfo = 'user=replication host=$IP_OF_UPSTREAM_SLAVE_OR_MASTER port=5432 sslmode=prefer sslcompression=1 krbsrvname=postgres'
recovery_target_timeline = 'latest'
archive_cleanup_command = '/usr/pgsql-9.3/bin/pg_archivecleanup /path/to/WALs %r'
restore_command = 'cp /path/to/WALs/%f "%p" 2>> /your/PGDATA/path/pg_log/standby.log'

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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: Schemas, Roles & Search Path
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question