| 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: | Whole Thread | Raw Message | 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?
| 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 |