"Doug McNaught" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > "P. Dwayne Miller" <[EMAIL PROTECTED]> 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? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster