| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pablobarbachano(at)yahoo(dot)es |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: backups and WAL |
| Date: | 2004-08-27 14:28:53 |
| Message-ID: | 10452.1093616933@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
pablobarbachano(at)yahoo(dot)es writes:
> 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?
You can't realistically do this in any pre-8.0 release; it's perhaps
doable in theory but there are too many gotchas to consider it a
trustworthy backup technique.
8.0 will have real support for log-based backup. Feel free to try out a
beta --- we could use more people testing this feature.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Browne | 2004-08-27 14:29:39 | Re: vacuum pg_attribute causes high load |
| Previous Message | G u i d o B a r o s i o | 2004-08-27 13:13:43 | REINDEX process |