-----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@turnstep.com
PGP Key: 0x14964AC8 200902081214
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAkmPE0IACgkQvJuQZxSWSsgk2gCeJoBSGZy6LgUZoSuNc5tGpG+y
5wAAoLndm/ggDECsNM2tFrYOsXA5TIw9
=6HJR
-----END PGP SIGNATURE-----