Postgres Pro
Downloads
Home   >   mailing lists

The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf - Mailing list pgsql-admin

From Arnold, Sandra
Subject The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf
Date
Msg-id 54E5385D47A89542BC678F5426799F3904961EF60F@OSTIEX01.osti.gov
Whole thread Raw
Responses Re: The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf  (Chander Ganesan <chander@otg-nc.com>)
Re: The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view
I am currently using the pg_hotbackup Perl script to backup my production PostgreSQL database.  However, the next production database is going to be close to a terrabyte in size.  We feel that a tar cvzf command is not the correct OS backup solution to use.  Instead we would like to use lvmsnapshot.  Is anyone using the pg_hotbackup script but instead of the tar cvzf OS command are they using lvmsnapshot?
 
Or, is anyone using lvmsnapshot and doing point-in-time recoveries?
 
Thanks,

Sandra Arnold
Sr. Database Administrator
DOE/OSTI
Oak Ridge, TN

pgsql-admin by date:

Previous
From: Major Services
Date:
Subject: Re: password authentication failed for user postgres
Next
From: Major Services
Date:
Subject: Restart failed with 'service postgresql restart'