Re: Need solution for weekly database "snapshot"

John R Pierce <pierce@xxxxxxxxxxxx> · Mon, 22 Apr 2013 10:59:28 -0700



    On 4/22/2013 10:05 AM, Moshe Jacobson
      wrote:

    
          Setup
            a slave.

          
        Not bad, but the transaction logs would fill up the file system.
        Besides, it would not be worth it to set up a whole database
        cluster just for this purpose.
      
        
      Any alternatives?
    
    
    if your file system supports it (ZFS, for instance), you /could/
    take a volume snapshot/clone, and then mount that and run a separate
    instance of PostgreSQL on it, using a different port number.  when
    done with your reports, you'd drop that instance and snapshot.

    
    we run a separate server (hardware and database) for our reporting
    systems as their workload is heavier than the realtime transaction
    system.

    
    -- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast