Skip site navigation (1) Skip section navigation (2)

The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf

From: "Arnold, Sandra" <ArnoldS(at)osti(dot)gov>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>,"pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf
Date: 2010-03-02 15:43:07
Message-ID: 54E5385D47A89542BC678F5426799F3904961EF60F@OSTIEX01.osti.gov (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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

Responses

pgsql-admin by date

Next:From: Major ServicesDate: 2010-03-02 16:43:20
Subject: Restart failed with 'service postgresql restart'
Previous:From: Achilleas MantziosDate: 2010-03-02 14:29:06
Subject: Very Dangerous bug in XA connection pooling and SL EJBs with jboss-4.2.3 & latest postgresql-8.4-701.jdbc3.jar

pgsql-general by date

Next:From: maria teresa tarquinoDate: 2010-03-02 16:54:32
Subject: I suspend the subscription
Previous:From: Said RamirezDate: 2010-03-02 15:27:58
Subject: Re: How to grant a user read-only access to a database?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group