Triggering ECS RunTask from AWS CloudFormation

Inevitably there will come a time where you’re deploying an application on Amazon ECS and you’ll need to fire a single-run command on deployment. This could be something like a database migration or something else that sets up your environment post-deployment that can’t, or shouldn’t be run within your container’s startup sequence (by using entrypoints/bootstrap […]

Creating users in PostgreSQL

This one has thrown me one too many times, and short of a better place to note this sequence of commands down, I’m posting it here. postgres=> CREATE USER new_user WITH PASSWORD ‘SuperSecurePassword’; CREATE ROLE postgres=> GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO new_user; GRANT postgres=> GRANT ALL PRIVILEGES ON ALL SEQUENCES […]

Configuring pfSense to work with BT Infinity native IPv6

A quick post this one. I’ve been scouring the internet trying to find the right settings in order to connect up my pfSense to use BT Infinity’s native IPv6 implementation. Finally found the magic combination, which I’m sharing here for future reference, and hopefully help anyone else that might find this post.