thanks Scott. i have read and used this article a lot of times before.
in section 24.3.2, step number 3 says
"3. Perform the backup, using any convenient file-system-backup tool such as
tar or
cpio. It is neither necessary nor desirable to stop normal operation of the database while you do this. "
so instead of tar or cpio, i am looking for the procedure where you can use hardware level snapshots of the postgres filesystem, which you can take on san (3par) or nas (netapp) or any other vendor hardware, and then mount the postgres filesystem snapshot to a different host.
i know a lot of ppl use this procedure, but cant find a good doc for this procedure.
regards
Jigar
On Sat, Aug 28, 2010 at 5:29 PM, Scott Marlowe
<scott.marlowe@gmail.com> wrote:
Specifically this section:
24.3.2. Making a Base Backup
--
"luck is truly where preparation meets opportunity"
--Randy Pausch