Backup without WAL files with Server shut down

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

Browse pgsql-admin by date

  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 ...