Re: [GENERAL] How to log query's from servers ?

2011-06-07 Thread Condor
On Tue, 07 Jun 2011 06:44:02 +0800, Craig Ringer wrote: On 06/06/2011 09:26 PM, Condor wrote: 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 ? http://www.postgresql.org/docs/current/static/sql-set.html

[GENERAL] How to log query's from servers ?

2011-06-06 Thread Condor
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 ? -- Regards, Condor --

Re: [GENERAL] How to log query's from servers ?

2011-06-06 Thread Craig Ringer
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

Re: [GENERAL] How to log query's from servers ?

2011-06-06 Thread Condor
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

Re: [GENERAL] How to log query's from servers ?

2011-06-06 Thread Scott Marlowe
On Mon, Jun 6, 2011 at 7:26 AM, Condor con...@stz-bg.com wrote: 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

Re: [GENERAL] How to log query's from servers ?

2011-06-06 Thread Craig Ringer
On 06/06/2011 09:26 PM, Condor wrote: 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 ? http://www.postgresql.org/docs/current/static/sql-set.html