ssh -i ~path\to\key.pem -o TCPKeepAlive=true ubuntu@ec2-xx-xxx-x-xxx.us-[region]-[#].compute.amazonaws.com
sudo apt-get update
sudo apt-get upgrade
sudo apt-get dist-upgrade
sudo reboot
sudo nano gpt.sh
#!/bin/bash
shopt -s nullglob
sudo sgdisk /dev/nvme0n1 --mbrtogpt --new=2:34:2047 --typecode=2:ef02
sudo partprobe
sudo grub-install /dev/nvme0n1
bash gpt.sh
sudo rm gpt.sh
sudo reboot
lsblk
df -hT
sudo growpart /dev/nvme0n1 1
sudo resize2fs /dev/root
sudo mkfs -t xfs -f /dev/nvme1n1
sudo mkdir /eph
sudo mount /dev/nvme1n1 /eph
Set count to the desired size of the swap partition in MB, often equal to RAM.
sudo dd if=/dev/zero of=/eph/swapfile bs=1M count=64425
sudo chmod 600 /eph/swapfile
sudo mkswap /eph/swapfile
sudo swapon /eph/swapfile
sudo swapon -s
sudo nano /etc/fstab
/eph/swapfile swap swap defaults 0 0
sudo reboot
sudo apt update
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt -y install postgresql-14 postgresql-contrib
sudo systemctl start postgresql.service
curl -s https://packagecloud.io/install/repositories/timescale/timescaledb/script.deb.sh | sudo bash
sudo apt-get install timescaledb-2-2.7.2-postgresql-14=2.7.2~ubuntu20.04
sudo systemctl restart postgresql