nplusp

How to deploy a Rails 7.1 app with Postgres and Kamal on a single server

I think you have looked at the tutorial from Mr. Heinemeier Hansson at least once or twice and have a similar setup.

rails new kamal_pg --css tailwind --skip-test --database=postgresql

cd kamal_pg

nplusp

# delete local tag '12345'
git tag -d 12345
# delete remote tag '12345' (eg, GitHub version too)
git push origin :refs/tags/12345
# alternative approach
git push --delete origin tagName
git tag -d tagName

nplusp

brew install libpq

gem install pg -- --with-opt-dir="/usr/local/opt/libpq"

bundle config --local build.pg --with-opt-dir="/usr/local/opt/libpq"
bundle install

nplusp

Keybase proof

I hereby claim:

• I am nplusp on github.
• I am nplusp (https://keybase.io/nplusp) on keybase.
• I have a public key whose fingerprint is 15FB 8132 60B8 3D73 44BC B9CF 5869 568A B841 34B0

To claim this, I am signing this object:

nplusp

ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

nplusp

# 1) Create your private key (any password will do, we remove it below)

$ cd ~/.ssh
$ openssl genrsa -des3 -out server.orig.key 2048


# 2) Remove the password

$ openssl rsa -in server.orig.key -out server.key

nplusp

cat /etc/postgresql/9.6/main/postgresql.conf | grep log_min_duration_statement
#log_min_duration_statement = -1	# -1 is disabled, 0 logs all statements
log_min_duration_statement = 100

sudo tail -f /var/log/postgresql/postgresql-9.6-main.log

nplusp

checkout:
  post:
    # Work around some silly configuration added by Circle that doesn't actually even do what they want it to.
    - git config --global --unset url.ssh://git@github.com:.insteadof

nplusp

bundle config --global jobs 3 # Number of cores - 1

nplusp

echo "puts User.count" | heroku run console --app=my-heroku-app --no-tty

cat some_script.rb | heroku run console --app=my-heroku-app --no-tty

heroku run bundle exec rails runner ./scripts/script.rb -a my-heroku-app

heroku run bash