Re: Using cp to back up a database?

Ron Johnson <ron.l.johnson@xxxxxxx> · Mon, 9 Oct 2017 11:41:37 -0500



    On 10/09/2017 11:33 AM, Jeff Janes
      wrote:

    
          On Mon, Oct 9, 2017 at 6:40 AM, Ron
            Johnson <ron.l.johnson@xxxxxxx>
            wrote:

            
               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();"

                      
            That's fine, as long as you have a wal archive. 
              Although I don't know what is "Incremental" about it. 

            
    From reading the docs, that field is just a label with no intrinsic
    meaning.

    
    -- 
World Peace Through Nuclear Pacification