On Mon, 06 Jun 2011 18:53:57 +0800, Craig Ringer wrote:
On 6/06/2011 4:14 PM, Condor wrote:
Hello ppl,
any one can tell me how i make my postgresql server to log commands
coming from another postgres server ? I have one postgresql and give
to
2 other sql server to access my db. I want to log all query's coming
only from one of the servers. Is that possibly ?
If the different servers log in with different user accounts or log
into different databases you could use database-level or user-level
SET commands to set log_statement for only one of them.
Otherwise: just grep the logs.
Can you explain little more how i can use database-level or user-level
SET commands to set log_statement for only one of them ?
From server that i want to log his query i log in to db on another
server
with: psql -U user -h 192.168.1.1 master_db. Here maybe I should say
that I wanna
monitor users that I gave them access to DB.
Every server use different username to connect. I can't use grep on
logs because
other two servers generate around 500 MB to 1 GB log file per day.
Probably, a little filter or patch on postgresql source code file which
manage logs to write log file
only if ip is the ip that i want will save me.
--
Regards,
Condor
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general