dvasdekis/postgrest-ec2

EC2 startup script to serve your RDS database via Postgrest

Postgrest on EC2

Creates an EC2 server with Postgrest running, pointing to your database (probably RDS).

What does the shell script (rhel7.sh) do?

It sets the instance to autoupdate, and installs postgrest as a system service, pointing to your database.

Install Option 1 - paste rhel7 as user-data (easier, less secure):

1. Copy the rhel7.sh file into the user-data field on a new RHEL7 EC2 instance. You don't need SSH permissions, so remove them.

2. Update the first few lines of the pasted user-data in the AWS console to your intended postgrest.conf file, and uncomment them.

Note: This method is less secure because your DB password will be stored in plaintext in your AWS logs

Install Option 2 - get it running manually (harder, more secure):

1. Start an EC2 instance with a RHEL 7.x image (t2.micro with 10GB of local storage is plenty). Ensure the instance can talk to the database - recommend that it's in the same VPC and availability zone. Add SSH permissions to the inbound rules of the VPC security group

2. Log in as ec2-user and copy your postgrest config file to /usr/local/bin/postgrest.conf

3. SSH in and run this: curl -sSL https://raw.githubusercontent.com/dvasdekis/postgrest-ec2/master/rhel7.sh | sudo sh

4. Remove SSH permissions from the inbound rules of the VPC security group. You ain't gonna need it.

postgrest-ec2's Issues

Set up CI on CircleCI

The script should be testable via CircleCI, but I'm not sure how long it would take to do.

Let me know if you want this.

Make Postgrest autoupdate with a cron job

Could set up a cron job that fetched the latest binary of Postgrest in the overnight run