Project

General

Profile

« Previous | Next » 

Revision 48352

Added by Tsampikos Livisianos almost 7 years ago

keep backup of stats db

View differences:

modules/uoa-stats-service/trunk/src/main/java/eu/dnetlib/data/statsmanager/StatsManager.java
45 45 

  		




  46
  46
  
    
        log.info("Backing up and Replacing public schema  with shadow in " + dataSource.getConnection().getMetaData().getURL() + " ...");


  		




  47
  47
  
    
        con.createStatement().execute("drop schema if exists backup CASCADE ;");


  		




  48
  
  
    
        //con.createStatement().execute("alter schema public rename to backup ;");


  		




  49
  
  
    
        con.createStatement().execute("drop schema if exists public CASCADE ;");


  		




  
  48
  
    
        con.createStatement().execute("alter schema public rename to backup ;");


  		




  
  49
  
    
        //con.createStatement().execute("drop schema if exists public CASCADE ;");


  		




  50
  50
  
    
        con.createStatement().execute("alter schema  shadow rename TO public ;");


  		




  51
  51
  
    
        log.info("All ops done!");


  		




  52
  52
  
    
        con.close();


  		












  

    
      modules/uoa-stats-service/trunk/src/main/resources/eu/dnetlib/data/statsmanager/springContext-statsManager.properties
    
  





  1
  1
  
    
services.statsManager.serviceName = uoa-stats-service


  		




  2
  2
  
    
services.statsManager.db.driverClassName = org.postgresql.Driver


  		




  3
  
  
    
services.statsManager.db.url = jdbc:postgresql://duffy.di.uoa.gr:5432/stats


  		




  
  3
  
    
services.statsManager.db.url = jdbc:postgresql://vatopedi.di.uoa.gr:5432/stats


  		




  4
  4
  
    
services.statsManager.db.username = sqoop


  		




  5
  5
  
    
services.statsManager.db.password = sqoop


  		




  6
  6
  
    
services.statsManager.historySchema = "stats_history"


  		




  ......




  15
  15
  
    
services.statsManager.actions.migrate =cacheController?action=migrate


  		




  16
  16
  
    
services.statsManager.actions.restore =cacheController?action=restore


  		




  17
  17
  
    

  		




  18
  
  
    
services.statsManager.shadowSearchServiceURL=http://duffy.di.uoa.gr:8080/shadowSearch/services/searchWebService


  		




  
  18
  
    
#services.statsManager.shadowSearchServiceURL=http://duffy.di.uoa.gr:8080/shadowSearch/services/searchWebService


  		




  19
  19
  
    

  		




  20
  20
  
    
services.statsManager.actions.prodURL=https://beta.openaire.eu/stats/


  		




  21
  21
  
    
services.statsManager.actions.testURL=https://test.openaire.eu/stats/


  		












Also available in:  Unified diff