| Lists: | pgsql-admin |
|---|
| From: | Chris Pesko <cpesko(at)organic(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | How do you manage WAL logs...... |
| Date: | 2001-10-16 00:02:52 |
| Message-ID: | 4.3.2.7.2.20011015165855.01e0cf00@mailhost.organic.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
I know WAL is new but how do you manage the WAL files. Do they need to get
deleted everytime you back up the db? What is the best way to backup a
Wharehouse? A transaction system? What do you do with the WAL files in
each case? Is there an option to not use WAL logs? Currently I'm just
using the pg_dumpall for lack of knowledge, but don't know what to do with
the WAL files. Can anyone help with this?
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Chris Pesko <cpesko(at)organic(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: How do you manage WAL logs...... |
| Date: | 2001-10-16 04:38:38 |
| Message-ID: | 8108.1003207118@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Chris Pesko <cpesko(at)organic(dot)com> writes:
> I know WAL is new but how do you manage the WAL files.
You don't. There is no reason for you to touch them or concern yourself
with them at all.
regards, tom lane