replication error

From: Anton Gorlov <stalker(at)altlinux(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: replication error
Date: 2017-02-28 14:54:48
Message-ID: b35b9162-c9b6-b580-015d-84309302554e@altlinux.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello.

I try setup replica from instructions located at
https://wiki.postgresql.org/wiki/Streaming_Replication

I copied data to slave, after psql -c "SELECT pg_start_backup('label',
true)" and start slave - i see in logs many message like

cp: cannot stat
'/var/lib/postgresql/9.6/main/archive/000000010000000000000012': No such
file or directory
2017-02-28 17:48:45 MSK [2333-3] LOG: redo starts at 0/12000098
2017-02-28 17:48:45 MSK [2333-4] LOG: consistent recovery state reached
at 0/120000D0
2017-02-28 17:48:45 MSK [2333-5] LOG: record with incorrect prev-link
10000/2470000 at 0/120000D0
2017-02-28 17:48:45 MSK [2332-1] LOG: database system is ready to
accept read only connections
2017-02-28 17:48:45 MSK [2339-1] LOG: started streaming WAL from
primary at 0/12000000 on timeline 1

on master node file 000000010000000000000012 located in pg_xlog
directory and copy to archive diectory after execute
psql -c "SELECT pg_stop_backup()" and after copy database data to slave.

What i doing wrong?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2017-02-28 15:23:51 Re: replication error
Previous Message Tom Lane 2017-02-28 04:37:49 Re: cpu hight sy% usage