Child pages
  • Release Test for LDE v1.0.5
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This test is designed to ensure that we can export all the previously-rejected (and new) TV programs. 

  1. Create dumps of current prod data for both BTA and LDE.
    1. On develro@phoebe run 

      pg_dump -h phoebe -U bta-ro -f bta.dump.txt --data-only bta-prod
      p: hwSvaL1e
      pg_dump --data-only -h phoebe -U lde-ro -f lde.dump.txt lde-prod
      p: 7WVEBTTfIvuh
    2. Copy the files over to the test server via your home machine:

      scp develro@phoebe:*dump.txt .
      scp *dump.txt bta@iapetus:
    3. On bta@iapetus, delete contents of the two databases and restore from the dumps. 

      [bta@iapetus ~]$ psql -d bta-devel
      delete from broadcasttranscodingrecord ;
      delete from programmediainfo ;
      delete from reklamefilmtranscodingrecord ;
      DELETE FROM thumbnailextractionrecord ;
      \q
      [bta@iapetus ~]$ psql -d bta-devel -f bta.dump.txt 
  • No labels