Thread: Snapshot and pg_hotbackup
Does anyone use OS snapshot as the file system backup solution in the pg_hotbackup instead of tar? Using tar for a small database is not a problem is when you have a database that will be close to a Terrabyte in size it can be a problem. I was wondering if changing the file system backup solution to a snapshot instead has been done. I have PostgreSQL databases on Red Hat Linux and x86 64 bit Solaris. The larger database will be on the Solaris server.
Thanks,
Sandra Arnold
Sr DBA
DOE/OSTI
Oak Ridge, TN
"Arnold, Sandra" <ArnoldS@osti.gov> wrote: > Using tar for a small database is not a problem is when you have a > database that will be close to a Terrabyte in size it can be a > problem. I was wondering if changing the file system backup > solution to a snapshot instead has been done. If snapshots turn out not to work well for you, and any significant portions of the data remain unchanged from one base backup to the next, you might want to check out this thread and the one it references: http://archives.postgresql.org/pgsql-admin/2009-07/msg00071.php -Kevin