Server Setup
Ubuntu server setup for RoR
December 11, 2023 07:28Server config below. Startting with Ubuntu 22.04LTS. Install Nginx and set SSL certificates Install Nginx sudo apt install nginx Open firewall ports sudo ufw allow 'Nginx HTTP' Set up Ngi...
Postgres Cheatsheet
December 11, 2023 09:41Link to source -> postgres-cheatsheet.md PSQL Magic words: psql -U postgres Some interesting flags (to see all, use -h or --help depending on your psql version): -E: will ...
Ubuntu Systemd service for Ruby on Rails
December 12, 2023 07:23This is an example of a systemd service file for starting a Ruby on Rails app automatically. File location is /etc/systemd/system [Unit]Description=ror-app-nameAfter=network.target [Service]Type=si...
Nginx Server Block - Before Certbot with PHP
December 13, 2023 10:10Example Nginx server block including PHP, before SSL setup with Certbot. server {listen 80;listen [::]:80;server_name example.com;root /var/www/example.com;index index.html index.htm index.php; loc...
Postgres Database Backup and Restore
December 18, 2023 17:17I moved some old web page data from some MYSQL tables that which had been updated and edited over the years. When diplayed on the new site the strange characters were showing up in the ...