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 ...>