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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Major Services | 2010-03-02 16:43:20 | Restart failed with 'service postgresql restart' |
Previous Message | Achilleas Mantzios | 2010-03-02 14:29:06 | Very Dangerous bug in XA connection pooling and SL EJBs with jboss-4.2.3 & latest postgresql-8.4-701.jdbc3.jar |
From | Date | Subject | |
---|---|---|---|
Next Message | maria teresa tarquino | 2010-03-02 16:54:32 | I suspend the subscription |
Previous Message | Said Ramirez | 2010-03-02 15:27:58 | Re: How to grant a user read-only access to a database? |