My name is Peter.
Pinned Loading
-
vim-config
vim-config PublicMy vim configuration files. Includes an idleFingers theme for vim!
-
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`
23CREATE ROLE owner CREATEDB LOGIN ENCRYPTED PASSWORD 'secret' CONNECTION LIMIT 3;
45ALTER ROLE owner SET statement_timeout = 20000;
-
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) 1CREATE ROLE owner LOGIN ENCRYPTED PASSWORD 'secret' CONNECTION LIMIT 3;
2ALTER ROLE owner SET statement_timeout = 20000;
3ALTER ROLE owner SET lock_timeout = 3000;
4ALTER ROLE owner SET idle_in_transaction_session_timeout = 3000; -- v9.6+
5
Something went wrong, please refresh the page to try again.
If the problem persists, check the GitHub status page or contact support.
If the problem persists, check the GitHub status page or contact support.