AWS ElasticBeansTalk Docker : リモートログインしてPostgresql に接続する手順

connect-to-postgres.md

Postgresqlに接続するまでの手順

1. log in docker container in ec2-user
2. apt-get update
3. apt-get install -y postgresql
4. apt-get install -y dnsutils

• this package is for nslookup

1. nslookup xxxx.yyyyyy.us-west-2.rds.amazonaws.com
2. psql -h <private-ip-address> -U <user-name> -d <database-name>

Postgresql Command

• show timezone;
• SELECT datname, pg_encoding_to_char(encoding) FROM pg_database;

docker-debug-on-elastic-beanstalk.md

• https://blog.cloudinvaders.com/connect-to-docker-daemon-on-aws-beanstalk-ec2-instance/

1. Log in on ec2 instance

ssh -i ~/.ssh/aws.pem ec2-user@<public ip address>

1. Input the following command.

sudo gpasswd -a ec2-user docker

1. log out ec2 and then log in again
2. you can do this.

docker ps

docker exec -i -t e662539785ed bash