how long a backend stayed connected - Mailing list pgsql-admin

From pgsql-admin
Subject how long a backend stayed connected
Date
Msg-id fc.000f567200e91202000f567200e91202.e9126c@fc.emc.com.ph
Whole thread Raw
List 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


pgsql-admin by date:

Previous
From: Sven Riedel
Date:
Subject: Problems setting up DB at a different location
Next
From: "Mike Krieger"
Date:
Subject: Re: FINAL: Multi-User PostgreSQL usage SECURITY