diff options
Diffstat (limited to 'software/postgres.page')
| -rw-r--r-- | software/postgres.page | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/software/postgres.page b/software/postgres.page index bdb01d8..32f2fe4 100644 --- a/software/postgres.page +++ b/software/postgres.page @@ -15,3 +15,23 @@ 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` +- https://www.citusdata.com/blog/2019/07/17/postgres-tips-for-average-and-power-user/ +- https://github.com/citusdata/pg_auto_failover +- https://repmgr.org/ + |