Re: psql and regex not like

2025-03-06 Thread François Lafont
uestion about bash. This works well for me: set +H psql -Xc "SELECT datname FROM pg_database WHERE datname !~ 'template|postgres' ORDER BY datname;" ~$ echo "!~" -bash: !~: event not found ~$ set +H ~$ echo "!~" !~ Bye. -- François Lafont

PG16 and replication, ensure a clean switchover after a stop of the primary server

2025-02-26 Thread François Lafont
e_io_concurrency = 200 random_page_cost = 1.1 track_activity_query_size = 8096 shared_preload_libraries = 'pg_stat_statements,auto_explain' pg_stat_statements.max = 1 auto_explain.log_min_duration = -1 # disable auto_explain extension currently --- -- François Lafont