At Wed, 8 Jun 2022 16:43:55 +0000, pgdba pgdba <postgresdba12@xxxxxxxxxxx> wrote in > hello everyone, > > I want to install a two-node streaming replication with postgresql version 11, but I'm getting this error when starting the service of my slave node. Can you support me? I couldn't find the solution. > > FATAL: could not receive timeline history file from the primary server: ERROR: could not open file "pg_wal/00000002.history": No such file or directory It seems like that the stanby is on TLI=1 and the primary is on 2 or greater (call it n). In that case, at replication start, the standby requests to the primary every history (0000000n.history) files from TLI=2 to TLI=n if the standby doesn't have. Thus, the message means 0000002.history has been somehow removed in pg_wal of the primary, but I'm not sure how come it happened. If you did remove some history files on primary, do not remove them for between the TLIs of primary and standby. > slave node has recovery.conf file and include primary_con_info informations. regards. -- Kyotaro Horiguchi NTT Open Source Software Center
