PostgreSQL: Connecting to PostgreSQL the right way the first time

https://www.liquidweb.com/kb/what-is-the-default-password-for-postgresql/

https://www.postgresqltutorial.com/postgresql-administration/psql-commands/

Do You Really Need Redis? How to Get Away with Just PostgreSQL

 https://spin.atomicobject.com/2021/02/04/redis-postgresql/

PostgreSQL articles

https://info.crunchydata.com/blog

PostgreSQL BRIN Indexes: Big Data Performance With Minimal Storage

https://info.crunchydata.com/blog/postgresql-brin-indexes-big-data-performance-with-minimal-storage

Postgresql - launch options

Run as a Background service:

To have launchd start postgresql now and restart at login:
  brew services start postgresql

Not as a Background service:
Or, if you don't want/need a background service you can just run:
  pg_ctl -D /usr/local/var/postgres start

Distributed Databases related - Citus & PostgreSQL

https://www.citusdata.com/blog/2018/11/30/why-rdbms-is-the-future-of-distributed-databases/
https://www.reddit.com/r/programming/comments/a1wwdh/why_the_rdbms_is_the_future_of_distributed/

PostgreSQL & Homebrew

https://stackoverflow.com/questions/15301826/psql-fatal-role-postgres-does-not-exist
If you're using postgres from Homebrew, then you want /usr/local/Cellar/postgresql/9.2.4/bin/createuser -s postgres (for version 9.2.4, obviously). 

PostgreSQL - full text search

https://stackoverflow.com/questions/13256645/postgres-full-text-search-multiple-columns-cross-table
https://codereview.stackexchange.com/questions/2364/sql-search-for-a-keyword-in-several-columns-of-a-table
https://www.postgresql.org/docs/current/static/textsearch.html 

A Job Queue System with PostgreSQL & Ruby

From blog.holistics.io
"How We Built A Job Queue System with PostgreSQL & Ruby For Our B2B SaaS Application"
https://blog.holistics.io/how-we-built-a-multi-tenant-job-queue-system-with-postgresql-ruby/

PostgreSQL & JSON data

Mar 2015
https://www.compose.com/articles/is-postgresql-your-next-json-database/

 Apr 2016
https://www.compose.com/articles/could-postgresql-9-5-be-your-next-json-database/

PostgreSQL - Backup & Restore using pgAdmin

https://www.pgadmin.org/docs/pgadmin3/1.22/backup.html
https://www.pgadmin.org/docs/pgadmin3/1.22/restore.html#restore