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
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 |