Production Backup and Recovery
Is it documented somewhere how to do on-line backups and then how to
recover from some event using those backups with no (or minimum) loss of
data?
"P. Dwayne Miller" <dmiller@espgroup.net> writes:
Is it documented somewhere how to do on-line backups and then how to
recover from some event using those backups with no (or minimum) loss of
data?
Right now there is no PIT recovery. All you can do is run pg_dump
whenever you want to make a backup. This will take a consistent
snapshot of the database and write it out as SQL code that will
recreate the database..
There has been talk of using the new WAL (write-ahead log) feature to
enable point-in-time recovery, but it is not currently implemented.
-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time... --Dylan
Import Notes
Reply to msg id not found: P.DwayneMillersmessageofMon02Jul2001132400-0400
"Doug McNaught" <doug@wireboard.com> wrote in message
news:m38zi7dyfl.fsf@belphigor.mcnaught.org...
"P. Dwayne Miller" <dmiller@espgroup.net> writes:
Is it documented somewhere how to do on-line backups and then how to
recover from some event using those backups with no (or minimum) loss of
data?Right now there is no PIT recovery. All you can do is run pg_dump
whenever you want to make a backup. This will take a consistent
snapshot of the database and write it out as SQL code that will
recreate the database..
By consistent... does that mean that committed transactions are completely
there, and uncommitted are not there at all?