Download RDS logs

The easer way to grab your RDS logs db_instance="awesome_db_identifier" aws_profile="corp_aws_profile" for logfile in $(aws --profile=${aws_profile} rds describe-db-log-files --db-instance-identifier ${db_instance} --query "DescribeDBLogFiles[].LogFileName" |jq -r '.|@sh'); do echo $logfile name=$(echo $logfile|

Simple Script to read linux process limits

#!/bin/bash if [ "$#" -ne "1" ]; then echo "" echo -e "\033[01;32mLimit checker\033[00m" echo -e "\033[01;37mUsage:\033[01;33m $0 process_name\033[00m" echo "" exit 0 fi return-limits(){ for process in $@; do process_

Copy/Duplicate an entire Postgres database on the same server.

Stolen from TablePlus Blog [https://tableplus.com/blog/2018/04/mysql-get-size-of-tables.html], Cool product check it out here [https://tableplus.com/]! First, lets check to see if the database has active connections.. SELECT pid,usename,client_addr,wait_event_type,wait_event,state,query,backend_type FROM pg_stat_activity

Fix Google's Shared Calendar issues for Apple Devices

Google has decided to treat Apple devices as 2nd class citizens in its ecosystem, you can access shared calendars, but you have to configure this... Here is the link to your hidden Calendar sync Settings..... [https://calendar.google.com/calendar/syncselect?pli=1]

Create a read-only role & user in PostgreSQL

Create the role for exampledb.... Note, make sure to connect to the db you want to effect privileges for... \c exampledb; CREATE ROLE exampledb_read_only_role; GRANT USAGE ON SCHEMA public TO exampledb_read_only_role; GRANT SELECT ON ALL TABLES IN SCHEMA public TO exampledb_read_only_role;