diff options
| author | Bryan Newbold <bnewbold@archive.org> | 2019-05-19 22:06:06 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@archive.org> | 2019-05-19 22:10:28 -0700 |
| commit | 04858ed7e251227e70a7105c8197abb194b6195a (patch) | |
| tree | e1a134483dd1719bf12072a447bdb859c31e3a8b /software | |
| parent | 98dc55a7c1dd61afb1372e74ee09741adb48a741 (diff) | |
| download | knowledge-04858ed7e251227e70a7105c8197abb194b6195a.tar.gz knowledge-04858ed7e251227e70a7105c8197abb194b6195a.zip | |
postgres temp databases
Diffstat (limited to 'software')
| -rw-r--r-- | software/postgres.page | 17 |
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` + |