On Wed, Dec 10, 2008 at 1:13 PM, Tino Schwarze <postgresql@xxxxxxx> wrote:
c) your are using lvm (or zfs) snapshots and know that postgres would run recovery after backup restore.
Hi Mike,
Do you know that a file system level backup is only useful if
> I am newbie with PostgreSQL. I have separate table space for my
> databases, which is located in separate folder, which is different to
> default. I would like to carry out file system level backup. Do I need
> to backup only folder with my table space or all pg folders.
a) the postgres instance is stopped
or
b) your are using WAL archiving and have an appropiate setup to tell PG
about backup starts and ends
c) your are using lvm (or zfs) snapshots and know that postgres would run recovery after backup restore.
--
Vladimir Rusinov
http://greenmice.info/
