backups and WAL - Mailing list pgsql-admin

From pablobarbachano@yahoo.es
Subject backups and WAL
Date
Msg-id 20040827080307.GA7494@vayven.info
Whole thread Raw
Responses Re: backups and WAL  (Gaetano Mendola <mendola@bigfoot.com>)
Re: backups and WAL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi, first of all thanks for postgresql, it has never given a problem
and is performing great.

Now my question: my employer wants to do backups every 12 hours, and
save the logs evry 2 hours to... Can I simply save the logs
(cp pg_xlog/* ...) or do I need something more elaborate?

Now in a restore situation ... I restore the database, and then what?
put the saved files back in the pg_xlog/ dir, then start postmaster
and magically all starts working? Am I correct or completely insane?
The documentation is not clear in that aspect...

Thanks in advance,
Pablo.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: regression database
Next
From: Gaetano Mendola
Date:
Subject: Re: backups and WAL