Using sshj connect to ec2 instance.

  • hostKey = “xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx”
  • hostDns = “”
  • publicKey = “file.pem”
  • USER_NAME = “ec2-user”

Connect to server

Execute command

Get file from server


Amazon Router53 and Simple Email Service

How to verify domain on Router53 and using it to SES sent mail.

I. Verify your domain on Router 53.

1. Go to screen dashboard of Router and click button Create Hosted Zone


2. After that click on your domain that you created and copy 4 Name Server on your notepad.


3. Go to screen dashboard of your domain and add four NS in your setting


4. After you config on your domain, may be we need wait more than hour to Router53 verifying your domain.
5. After verify sucessful, go to dashboard of AWS SES. Remember that SES no support Region Tokyo then you should choose another Region to using AWS SES. Now you will verify your domain that you created on Router53 on AWS SES.


6. After that go to your domain that you created on dashboard SES. And copy two value TXT NAME and TXT VALUE on notepad.


7. Come back to dashboard of Router53. Create new record set and paste two value that you copied.


II. Using sample code to test.

Please install AWS SDK on eclipse and enter your ACCESS_KEY and SECRET_KEY.
  • NOTE : required library from


III. Document about SES

1. AWS SES Limit

Import and export using command line.


  • Export to gzip
  • Import
  • Export table to csv
  • Export from console of EC2

Regex Explanation:

  • s/// means substitute what’s between the first // with what’s between the second //
  • the “g” at the end is a modifier that means “all instance, not just first”
  • ^ (in this context) means beginning of line
  • $ (in this context) means end of line

So, putting it all together:

II. PostgreSQL

  • Import

  • Export database

  • Export schema

  • Get size of all table in database of refshift