On Wednesday 20 August 2003 11:56, Ramil Sagum wrote:
> pero that's weird, i'm currently at the debug level "notice", and i don't
> see any query logs.
i did some more testing.
1. generally, you want server_min_messages and log_min_error_statement
to be the same level.
2. if they are both at notice, and log_statement=false, you will not get
queries in your log.
3. if they are both at notice, and log_statement=true, you will get
queries.
4. if they are both at debug1, you will get queries in your log whether
or not log_statement is true.
i find that service postgresql reload is fine on a hot database. no need to
stop and start the database. just reload the config and it will start logging
queries.
but of course this is just on a test database (that's restoring a full dump of
my real database, so it's actually crunching some real data. :). i wouldn't
dare to try that on my real server until the weekend too :).
good luck.
tiger
--
Gerald Timothy Quimpo gquimpo*hotmail.com tiger*sni*ph
http://bopolissimus.sni.ph
Public Key: "gpg --keyserver pgp.mit.edu --recv-keys 672F4C78"
It is highly likely that, in the future, any fresh installs of
Windows NT4 / XP / 2000 / 2003 will be `owned' by a dcom worm
in less time than it takes to download the patch.
-- from Full Disclosure, by [EMAIL PROTECTED]
--
Philippine Linux Users' Group (PLUG) Mailing List
[EMAIL PROTECTED] (#PLUG @ irc.free.net.ph)
Official Website: http://plug.linux.org.ph
Searchable Archives: http://marc.free.net.ph
.
To leave, go to http://lists.q-linux.com/mailman/listinfo/plug
.
Are you a Linux newbie? To join the newbie list, go to
http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
