Hello,
my pg version is 11, I use pg_basebackup+wal archive files to backup the database. I tried to restore the db to the latest wal archive file.
I restored the pg_basebackup file first, restored wal archive files to the archive folder, and created the recovery.conf file, which only has the "restore_command" in it.
when I started up the pg service, it didn't recover any wal archive files from archive folder with restore_command.
may I know how pg determines which next wal archive file needs to be fetched from archive folder?
how to troubleshooting the recover procedure, and how to check if restore_command is called?
thanks,
James