Re: [GENERAL] logging connections

2006-01-21 Thread Nikola Ivanov
You need to edit your postgresql.conf file and in the "Error reporting and logging" section set "log_connections=true", "log_disconnections=true", and "log_hostname=true" On 1/20/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote: i want to know, how i can log connections to postgres. the sampl

Re: [GENERAL] Postgres using 100% CPU

2006-02-16 Thread Nikola Ivanov
I found the pid of the postgres process that was consuming all the CPU. I turned the stats back on (and reloaded the conf file), but when I query pg_stat_activity I get nothing back. No records. On 2/15/06, Merlin Moncure <[EMAIL PROTECTED]> wrote: n 14 Feb 2006 06:46:48 -0800, Nik <[EMAIL PROTECT

Re: [GENERAL] Insert into partition table hangs

2006-06-10 Thread Nikola Ivanov
Database is running on Windows 2003 Advanced Server and it is PostgreSQL 8.1.3.The Java application is running from a remote machine running Windows XP Professional SP2.On 6/9/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Qingqing Zhou" <[EMAIL PROTECTED]> writes:> A wild guess is that when we continue