From: | gdid(at)gmx(dot)de (G(dot) W(dot)) |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Backup without WAL files with Server shut down |
Date: | 2003-05-15 11:09:41 |
Message-ID: | a8446a25.0305150309.269fde06@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I'd like to incrementally backup changed files only from a notebook's
pg_data directory to low capacity media (eg.floppy disks / zip
diskds), so I'd like to exclude the WAL files.
I've read about WAL, but I didn't find a definitive answer to the
following question:
-> Does loosing WAL files really matter when all server processes have
been shut down correctly, e.g. with all table data beeing in
consistent state?
And if it does: what kind of information gets lost?
Or the other way around: is it possible to shut down the server, do
the backup excluding WAL, and, if necessary, restore the data, call
pg_restorexlog without doing something bad??
Regards,
Gunter
From | Date | Subject | |
---|---|---|---|
Next Message | Raphael Bauduin | 2003-05-15 12:09:03 | pg_proc.prosrc -> can I see the function's source? |
Previous Message | Bruno Mattarollo | 2003-05-15 09:47:47 | Re: Can't drop a table ... |