how long backends stay connected

From: "pgsql-admin" <pgsql-admin(at)fc(dot)emc(dot)com(dot)ph>
To: pgsql-admin(at)postgresql(dot)org
Subject: how long backends stay connected
Date: 2001-09-19 15:33:16
Message-ID: fc.000f567200e91202000f567200e91202.ea4619@fc.emc.com.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Guys!

I just want to know how to configure postgresql.conf
such that it will show in /var/log/posgresql when a backend
exits in PostgreSQL 7.1.3. Before, in PostgreSQL 7.0.3,
I was able to determine the length in time of a backend connection
by looking at line 'started: ...' and this line

pg-703$ cat /var/log/postgresql
<cut>
Sep 16 07:04:57 pg-703 postgres[21383]: proc_exit(0)
Sep 16 07:04:57 pg-703 postgres[21383]: shmem_exit(0)
Sep 16 07:04:57 pg-703 postgres[21383]: exit(0)
<cut>

Here is how i started/configured PostgreSQL 7.1.3.

pg-703$ cat /var/lib/pgsql/data/postmaster.opts
/usr/bin/postmaster
-p 5432
-D /var/lib/pgsql/data
-B 64
-b /usr/bin/postgres
-i
-N 32

pg-703$ cat /var/lib/pgsql/data/pg_options
verbose=2
query=1
syslog=1
hostlookup
showportnumber

Here is how my postgresql.conf (PostgreSQL 7.1.3) looks like

pg-713$ cat /var/lib/pgsql/data/postgresql.conf
tcpip_socket = true
hostname_lookup = true
show_source_port = true
max_connections = 128
sort_mem = 20480 # 20M
shared_buffers = 32768 # 256M
syslog = 2
log_connections = true
debug_print_query = true
debug_pretty_print = true

Thank you very much.

sherwin

Browse pgsql-admin by date

  From Date Subject
Next Message David Stanaway 2001-09-20 06:51:15 pg_dump fails
Previous Message Oliver Elphick 2001-09-19 04:13:48 Re: Problems setting up DB at a different location