Page History

...

1. Create dumps of current prod data for both BTA and LDE.

   1. On develro@phoebe run 

      Code Block
      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 pg_dump -F custom -h phoebe -U lde-ro -f lde.dump.custom lde-prod p: 7WVEBTTfIvuh

   2. Copy the files over to the test server via your home machine:

      Code Block
      scp develro@phoebe:*dump* . scp *dump* bta@iapetus:

   3. On bta@iapetus, delete contents of the two databases and restore from the dumps. 

      Code Block
      [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

      Code Block
      [bta@iapetus ~]$ psql -d larm-doms-exporter-devel -U larmde -h iapetus -W p: LVf0lLbb larm-doms-exporter-devel=> delete from domsexportrecord ; \q [bta@iapetus ~]$ pg_restore -d larm-doms-exporter-devel -U larmde -h iapetus --data-only -W lde.dump.custom p: LVf0lLbb

2. Install LDE on lde@iapetus

3. Set REJECTED exports to PENDING 

   Code Block
   larm-doms-exporter-devel=> update domsexportrecord set state='PENDING' where state='REJECTED';

4. Run the producerconsumer.
5. Get new programs by running the consumerproducer.
6. Run the producer consumer again.