Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Today we will look into the requested WAL segment 000000020000000000000006 has already been removed error.
I will share the following error with its solution, after switchover between primary and standby in PostgreSQL. (Database version : PostgreSQL 13)
Error :
LOG: started streaming WAL from primary at 0/6000000 on timeline 2
FATAL: could not receive data from WAL stream: ERROR: requested WAL segment 000000020000000000000006 has already been removed
Solution :
We copy the missing archives from the primary database to the pg_wal directory in the standby database.
1 | <span id="30af" class="gi ll kd ih lm b dn ln lo l lp" data-selectable-paragraph=""><strong class="lm ii">$ scp -r 000000020000000000000006 postgres@<standby_server_ip>:/var/lib/pgsql/13/data/pg_wal</strong></span> |
After copying the missing archives, we restart the backup database.
1 | <span id="3a3d" class="gi ll kd ih lm b dn ln lo l lp" data-selectable-paragraph=""><strong class="lm ii">$ pg_ctl -D /var/lib/pgsql/13/data stop</strong></span><span id="70bc" class="gi ll kd ih lm b dn lq lr ls lt lu lo l lp" data-selectable-paragraph=""><strong class="lm ii">$ pg_ctl -D /var/lib/pgsql/13/data start</strong></span> |
