34d2977b5df7

Update
[view raw] [browse files]
author Steve Losh <steve@stevelosh.com>
date Mon, 25 Sep 2023 13:37:31 -0400
parents 3c6edc9a220d
children 34034dcd18ca
branches/tags (none)
files README.markdown

Changes

--- a/README.markdown	Mon Sep 25 11:53:56 2023 -0400
+++ b/README.markdown	Mon Sep 25 13:37:31 2023 -0400
@@ -1041,3 +1041,20 @@
 (i.e. of itself).  But when heat is applied, other proteins unfold and hsp90
 starts chaperoning them more, which leaves HSF1 free to enter the nucleus and
 enhance transcription of hsp90.
+
+Remembering how to create a local Postgres DB for testing:
+
+    sudo -u postgres psql
+
+    postgres=# CREATE DATABASE example;
+    CREATE DATABASE
+
+    postgres=# CREATE USER testuser WITH PASSWORD 'pass';
+    CREATE ROLE
+
+    postgres=# GRANT ALL PRIVILEGES ON DATABASE example TO testuser;
+    GRANT
+
+    postgres=# \q
+
+    psql postgresql://testuser:pass@localhost:5432/example