I got error on postgres

[sout saret]

cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed

cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed

cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed

cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed

cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed

cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed

[e***@ezakus.com]

Seem's that your primary server is not able to copy wals in your /home/postlog/archive/ path.
Try to empty it and verify if it's filled.

Modify you're primary and secondary postgresql.conf file increasing the wal_keep_segments value to have time to make you're pg_basebackup.

It seems that when you finish you're pg_basebackup, the wal's are out of date and the secondary can not resynchronize.

#------------------------------------------------------------------------------
# REPLICATION
#------------------------------------------------------------------------------

# - Sending Server(s) -

# Set these on the master and on any standby that will send replication data.

max_wal_senders = 5 # max number of walsender processes
# (change requires restart)
wal_keep_segments = 64 # in logfile segments, 16MB each; 0 disables

[Fernando Moreira]

Post by sout saret
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed

I suggest you perform the rsync again, this error has happened to me and to accomplish RSYNC returned to work again.

[Fernando Moreira]

Post by sout saret
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/0000000100000010000000A8': No such file or directory
cp: cannot stat `/home/postlog/archive/00000002.history': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000010000000A8 has already been removed

I suggest you perform the rsync again, this error has happened to me and to accomplish RSYNC returned to work again.