PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15785
PG Version11.0
OSlinux
Opened2019-04-29 08:43:34+00
Reported byram pratap maurya
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15785
Logged by:          ram pratap maurya
Email address:      (redacted)
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

Messages

DateAuthorSubject
2019-04-29 08:43:34+00PG Bug reporting formBUG #15785: create slave through archive log replication
2019-04-30 14:32:43+00Euler TaveiraRe: BUG #15785: create slave through archive log replication
2019-05-02 12:43:35+00Euler TaveiraRe: BUG #15785: create slave through archive log replication