question about database recover proceduers

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

question about database recover proceduers

jian xu
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
Reply | Threaded
Open this post in threaded view
|

Re: question about database recover proceduers

jian xu
oh, I think I figured it out. I enabled the debug mode, 
log_min_messages = debug5
log_min_error_statement = debug5
and saw the recovery steps detail in the log file, it also shows the status of restore command.
it turns out my restore command had problem, after I fixed it, the db recovery works.
thanks
James

From: jian xu <[hidden email]>
Sent: Monday, January 4, 2021 12:54
To: [hidden email] <[hidden email]>
Subject: question about database recover proceduers
 
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