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