Search Postgresql Archives

Re: PostgreSQL-11 Streaming Replication Slave Recovering

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Also this is postgresql Log(Debug1 level) . after i restart slave node this logs accours.
/var/lib/pgsql/11/data/log/postgresql-Fri.log
2019-03-22 12:17:57.869 +03 [31760] LOG:  redo starts at 0/C000098
2019-03-22 12:17:57.869 +03 [31760] LOG:  consistent recovery state reached at 0/C0000D0
2019-03-22 12:17:57.869 +03 [31760] LOG:  invalid record length at 0/C0000D0: wanted 24, got 0
2019-03-22 12:17:57.870 +03 [31757] LOG:  database system is ready to accept read only connections
2019-03-22 12:17:57.877 +03 [31764] LOG:  started streaming WAL from primary at 0/C000000 on timeline 1


Ali Mumcu <alimumcu1077@xxxxxxxxx>, 22 Mar 2019 Cum, 12:07 tarihinde şunu yazdı:
Hello Friends,

I wanna to create Streaming Replication with 2 Node(1 Master, 1 Slave)
After i create streaming replication, streaming is okay , and than  when i add new record on master , than on slave records occurs  autamaticly.

but When i look service status on slave server i "see startup recovering 00000001000000000000000A"


[root@slave]# systemctl status postgresql-11
● postgresql-11.service - PostgreSQL 11 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-11.service; disabled; vendor preset: disabled)
   Active: active (running) since Fri 2019-03-22 11:52:17 +03; 22s ago
     Docs: https://www.postgresql.org/docs/11/static/
  Process: 29349 ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 29355 (postmaster)
   CGroup: /system.slice/postgresql-11.service
           ├─29355 /usr/pgsql-11/bin/postmaster -D /var/lib/pgsql/11/data/
           ├─29357 postgres: logger
           ├─29358 postgres: startup   recovering 000000010000000000000008
           ├─29359 postgres: checkpointer
           ├─29360 postgres: background writer
           ├─29361 postgres: stats collector
           └─29362 postgres: walreceiver   streaming 0/A0000D0

when on master create new wal_file(like  000000010000000000000009)  and then on slave this is updating on slave like  "startup   recovering 000000010000000000000009  "

Is that a problem or not i dont know?

Master And Slave Postgresql.conf file
listen_addresses = '*'
wal_level = replica
synchronous_commit = on
max_wal_senders = 10
wal_keep_segments = 64
hot_standby = on
hot_standby_feedback = on 

Slave Recovery.conf file
standby_mode = on
primary_conninfo = 'host=master_ip  user=user password=password
application_name=slave'
recovery_target_timeline = 'latest' 


Also i trace postgresql process on slave Node  . This is results
[root@slave os1077]# strace -p 29358
strace: Process 29358 attached
epoll_wait(4, [], 1, 639)               = 0
close(4)                                = 0
read(7, 0x7ffe72a52007, 1)              = -1 EAGAIN (Resource temporarily unavailable)
epoll_create1(EPOLL_CLOEXEC)            = 4
epoll_ctl(4, EPOLL_CTL_ADD, 11, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=34908528, u64=34908528}}) = 0
epoll_ctl(4, EPOLL_CTL_ADD, 7, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=34908552, u64=34908552}}) = 0
epoll_wait(4, strace: Process 29358 detached
 <detached ...>




--
ALİ MUMCU 
İSTANBUL ÜNİVERSİTESİ
BİLGİ İŞLEM DAİRE BAŞKANLIĞI 
Dahili:11210

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux