summaryrefslogtreecommitdiffstats
path: root/software
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2019-05-19 22:06:06 -0700
committerBryan Newbold <bnewbold@archive.org>2019-05-19 22:10:28 -0700
commit04858ed7e251227e70a7105c8197abb194b6195a (patch)
treee1a134483dd1719bf12072a447bdb859c31e3a8b /software
parent98dc55a7c1dd61afb1372e74ee09741adb48a741 (diff)
downloadknowledge-04858ed7e251227e70a7105c8197abb194b6195a.tar.gz
knowledge-04858ed7e251227e70a7105c8197abb194b6195a.zip
postgres temp databases
Diffstat (limited to 'software')
-rw-r--r--software/postgres.page17
1 files changed, 17 insertions, 0 deletions
diff --git a/software/postgres.page b/software/postgres.page
index bdb01d8..7d05074 100644
--- a/software/postgres.page
+++ b/software/postgres.page
@@ -15,3 +15,20 @@ Basic status from the psql command line:
\l+ (list databases)
\dt+ (describe table)
+
+## Temporary Databases in Tests
+
+Try `pg_tmp`, though it may not work with high concurrency (due to internal
+postgres locking), and might need special configuration in CI environments.
+
+Debian also ships with `pg_virtualenv` for temporary databases.
+
+---------
+
+More refs/links:
+
+- https://stackoverflow.com/questions/9604723/alternate-output-format-for-psql
+- https://brandur.org/postgres-connections
+- https://www.citusdata.com/blog/2017/07/16/customizing-my-postgres-shell-using-psqlrc/
+- `bind "^R" em-inc-search-prev`
+