Replication terminated by primary server

Поиск
Список
Период
Сортировка
От Nicolau Roca
Тема Replication terminated by primary server
Дата
Msg-id 50040095.7080501@uib.cat
обсуждение исходный текст
Список pgsql-general
Hi,
we have configured a synchronous master-slave replication.
Node "postgres1" is the master, while node "postgres2" is the slave.

It works fine, but when restarting the master (using "pg_ctl restart"),
the replication is broken. In the slave log we have the following message:

2012-07-16 13:10:20 CESTFATAL:  replication terminated by primary server

There is a process in the slave which indicates the file the slave is
waiting for:

[postgres@postgres2 walpostgres1]$ ps -ef | grep start
postgres  1874  1872  0 Jun19 ?        00:01:04 postgres: startup
process   waiting for 000000010000000C000000A6

Once we manually copy this file from the master (in path
$PGDATA/pg_xlog) to the archive location (in the slave), the replication
is resumed.

[postgres@postgres1 pg_xlog]$ scp 000000010000000C000000A6
postgres2:/home/postgres/walpostgres1
000000010000000C000000A6 100%   16MB  16.0MB/s   00:01

And in the slave log:
2012-07-16 13:16:03 CESTLOG:  restored log file
"000000010000000C000000A6" from archive
2012-07-16 13:16:03 CESTLOG:  record with zero length at C/A60000B0
2012-07-16 13:16:03 CESTLOG:  unexpected pageaddr C/84000000 in log file
12, segment 166, offset 0
2012-07-16 13:16:03 CESTLOG:  streaming replication successfully
connected to primary

Is this a configuration issue?

The archive_command in postgresql.conf in the master is:
archive_command = 'scp %p postgres2:/home/postgres/walpostgres1/%f'

Thank you
Best regards,
Nicolau

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

Предыдущее
От: Olga Vingurt
Дата:
Сообщение: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
Следующее
От: raghu ram
Дата:
Сообщение: Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.