how do you recover a postgresql online backup

Started by Mark McWilliamsover 24 years ago2 messagesgeneral
Jump to latest
#1Mark McWilliams
mark.mcwilliams@mindspring.com

Can someone tell me how to recover a PostgreSQL online backup?
There is nothing in the documentation, and this is the only thing
keeping me from using Oracle over PostgreSQL. Assuming of
course using WAL (write ahead logging).

Thanks

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Mark McWilliams (#1)
Re: how do you recover a postgresql online backup

Mark McWilliams <mark.mcwilliams@mindspring.com> writes:

Can someone tell me how to recover a PostgreSQL online backup?
There is nothing in the documentation, and this is the only thing
keeping me from using Oracle over PostgreSQL. Assuming of
course using WAL (write ahead logging).

You don't have to do anything. The postmaster automatically arranges to
replay any uncheckpointed log entries upon restart after a crash.

regards, tom lane