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?
Sr. Database Administrator
Oak Ridge, TN
pgsql-admin by date
|Next:||From: Major Services||Date: 2010-03-02 16:43:20|
|Subject: Restart failed with 'service postgresql restart'|
|Previous:||From: Achilleas Mantzios||Date: 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 tarquino||Date: 2010-03-02 16:54:32|
|Subject: I suspend the subscription|
|Previous:||From: Said Ramirez||Date: 2010-03-02 15:27:58|
|Subject: Re: How to grant a user read-only access to a database?|