Find (and kill) process locking port 3000 on Mac

lsof -i :3000

kill -9 <PID>

postgres pg_dump database from AWS RDS

Run the below command from your terminal

pg_dump -h <host> -U <username> -f <filename>.sql
 <database-name>

If you only want to download schema of the database add --schema-only

pg_dump -h <host> -U <username> -f <filename>.sql --schema-only <database-name>

heroku check log of web dyno

heroku logs --tail --dyno=web --remote heroku

heroku logs --tail --dyno=web -a urgency-dev

PG: Connection to localhost:5432 refused

PG::ConnectionBad: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket “/tmp/.s.PGSQL.5432”

$ brew services stop postgresql
$ rm /usr/local/var/postgres/postmaster.pid # adjust path accordingly to your install
$ brew services start postgresql

another solution that worked for me https://dba.stackexchange.com/a/209337

Find process locking port 3306 on Mac

sudo lsof -i tcp:3306 

Quit MySQL

sudo launchctl unload -F /Library/LaunchDaemons/homebrew.mxcl.mysql@5.7.plist

 

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’

sudo chown -R _mysql:mysql /usr/local/var/mysql && sudo brew services restart mysql@5.7

macos: Start/Stop Apache & MySQL

Apache
sudo apachectl start
sudo apachectl stop
sudo apachectl restart
MySQL
brew services start mysql
brew services stop mysql
brew services restart mysql

Upgrade Heroku Postgres to Hobby Basic Plan

• heroku maintenance:on –remote testing
• heroku addons:create heroku-postgresql:hobby-basic –remote testing
• heroku pg:wait –remote testing
• heroku pg:copy DATABASE_URL HEROKU_POSTGRESQL_ORANGE_URL –remote testing
• heroku pg:promote HEROKU_POSTGRESQL_ORANGE_URL –remote testing
• heroku pg:info –remote testing
• heroku maintenance:off –remote testing

Useful Commands for Mac

[Postfix]

• • • Check the Postfix queue by running mailq
    • Delete all emails from the queue: sudo postsuper -d ALL
    • Delete all emails in the deferred queue: sudo postsuper -d ALL deferred

   

Brew Memcached: To have launchd start memcached now and restart at login

brew services start memcached