-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 >> * psql doesn't do multi-line readline > I thought it started doing that in 8.2 or 8.3. At least on linux. It combines all lines into a single statement, which is handy, but things like this still trip it up: psql#> CREATE <return> psql-#> TAB <tab> > This, very much this. I would kill to be able to have each db in a > cluster have its own logging, settings, shared_buffers, etc. The > whole shared mostly environment makes scaling to > 1 db on a server a > troublesome task Just in case you weren't aware, some settings /can/ be changed per database with: ALTER DATABASE prod SET random_page_cost = 2; ALTER DATABASE fooz SET work_mem = '32 MB'; Not the logging and shared_buffers though... - -- Greg Sabino Mullane greg@xxxxxxxxxxxx PGP Key: 0x14964AC8 200902081214 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAkmPE0IACgkQvJuQZxSWSsgk2gCeJoBSGZy6LgUZoSuNc5tGpG+y 5wAAoLndm/ggDECsNM2tFrYOsXA5TIw9 =6HJR -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
