Pinned Loading

1. vim-config vim-config Public

   My vim configuration files. Includes an idleFingers theme for vim!

   Vim Script 4 2

2. A postgres configuration for RDS and... A postgres configuration for RDS and self-managed postgres databases. Based on my guide (https://tightlycoupled.io/goto-postgres-configuration-for-rds-and-self-managed-postgres/)

   1

   -- Copy/paste this file or execute with `psql -f thisfile.sql`

   2

   3

   CREATE ROLE owner CREATEDB LOGIN ENCRYPTED PASSWORD 'secret' CONNECTION LIMIT 3;

   4

   5

   ALTER ROLE owner SET statement_timeout = 20000;

3. A base setup for new self-managed po... A base setup for new self-managed postgres databases. See related guide (https://tightlycoupled.io/my-goto-postgres-configuration-for-web-services/). Also, please make sure to change all the passwords from `secret` to something suitable. !! Update !! see this gist for a config that works for self-managed and RDS databases: https://gist.github.com/paydro/dd0be658da6ce0f142fa24b534472bea)

   1

   CREATE ROLE owner LOGIN ENCRYPTED PASSWORD 'secret' CONNECTION LIMIT 3;

   2

   ALTER ROLE owner SET statement_timeout = 20000;

   3

   ALTER ROLE owner SET lock_timeout = 3000;

   4

   ALTER ROLE owner SET idle_in_transaction_session_timeout = 3000; -- v9.6+

   5