PostgreSQL-11 Streaming Replication Slave Recovering

From: Ali Mumcu <alimumcu1077(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: PostgreSQL-11 Streaming Replication Slave Recovering
Date: 2019-03-22 09:07:27
Message-ID: CAByegeKOw996zjiFCke4Enuz1PCaO+NO6eJo0Qm57_choVj0qA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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(at)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 ...>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ali Mumcu 2019-03-22 09:23:09 Re: PostgreSQL-11 Streaming Replication Slave Recovering
Previous Message Andrus 2019-03-22 09:00:49 How to check is connection encrypted