Using cp to back up a database?

Ron Johnson <ron.l.johnson@xxxxxxx> · Mon, 9 Oct 2017 08:40:46 -0500



    Hi,

    
    v8.4.20

    
    This is what the current backup script uses:

    
      /usr/bin/psql -U postgres -c "SELECT
            pg_start_backup('Incrementalbackup',true);"
      
      cp -r /var/lib/pgsql/data/*
            $dumpdir/data/
        
      /usr/bin/psql -U postgres template1 -c
            "SELECT pg_stop_backup();"

          
    Should it use rsync or pg_dump instead?

    
    Thanks

    
    -- 
World Peace Through Nuclear Pacification