BUG #15785: create slave through archive log replication

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: rampratap0000(at)gmail(dot)com
Subject: BUG #15785: create slave through archive log replication
Date: 2019-04-29 08:43:34
Message-ID: 15785-807558ee262e8923@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15785
Logged by: ram pratap maurya
Email address: rampratap0000(at)gmail(dot)com
PostgreSQL version: 11.0
Operating system: linux
Description:

I have one master and slave1 and i am creating one more slave through
archive log , but is showing below error after 4 hr replication.

cp: cannot stat
/var/lib/pgsql/11/data/pg_log_archive/0000000100002C2F0000000A No such file
or directory
2019-04-29 11:29:43.518 IST [852] LOG: started streaming WAL from primary
at 2C2F 28000000 on timeline 1
2019-04-29 11 2943.518 IST [852] FATAL could not receive data from WAL
stream: ERROR: requested WAL segment 0000000100002C2F0000000A has already
been removed

and when we check archive log in directory :pg_log_archive on Master this
archive log is present "0000000100002C2F0000000A".

can you suggest how to confirm slave to replicate through archive log.

please fine below configuration details of recovery.conf slave2 and
pg_hba.conf file of slave2

Recovery.conf:

standby_mode = 'on'
primary_conninfo = 'user=postgres passfile=''/var/lib/pgsql/.pgpass''
host=XXX.XXX.X.XX port=5432 sslmode=prefer sslcompression=0
krbsrvname=postgres target_session_attrs=any'
restore_command = 'cp /var/lib/pgsql/11/data/pg_log_archive/%f "%p"'

pg_hba.conf :

# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
# IPv6 local connections:
host all all ::1/128 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres trust
#host replication postgres 127.0.0.1/32 trust
#host replication postgres ::1/128 trust

host replication replication XXX.XXX.X.XX/32 md5
host replication postgres XXX.XXX.X.XX/32 trust
host replication replication 127.0.0.1/32 md5
host replication postgres 127.0.0.1/32 trust
host all all 0.0.0.0/0 md5

but is showing below error after 5 hr replication.

cp: cannot stat
`/var/lib/pgsql/11/data/pg_log_archive/0000000100002C2F0000000A': No such
file or directory
2019-04-29 11:29:43.518 IST [852] LOG: started streaming WAL from primary
at 2C2F/28000000 on timeline 1
2019-04-29 11:29:43.518 IST [852] FATAL: could not receive data from WAL
stream: ERROR: requested WAL segment 0000000100002C2F0000000A has already
been removed

and when we check archive log in directory :pg_log_archive on Master this
archive log is present "0000000100002C2F0000000A".

can you suggest

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jozef Mlich 2019-04-29 08:49:11 Re: crash of postgresql 11.2-2PGDG.rhel7 in StartupXLOG () at xlog.c:6355
Previous Message neelaveni 2019-04-29 08:43:27 Re: Reg: Postgresql8.3 Using on Ubuntu