Skip site navigation (1) Skip section navigation (2)

Re: turning on debug without restarting postgres

From: "Rainer Mager" <rmager(at)vgkk(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: turning on debug without restarting postgres
Date: 2001-09-27 11:09:04
Message-ID: NEBBJBCAFMMNIHGDLFKGGEDDFCAA.rmager@vgkk.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

	Thanks for the answer. I looked at this and I think it might not work for
us. The thing is that we have a connection pool that maintains connections
to the db so all connections being closed at the same time will never
happen. Does this pg_ctl thing do VERY clever restarting like spawning a new
back end, as each connection closes removing it from the old back end, and
directing all new connections to the new backend until all old connections
are closed?

Thanks,

--Rainer

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Herbert Rabago Ambos
> Sent: Friday, September 28, 2001 7:12 AM
> To: Rainer Mager
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] turning on debug without restarting postgres
>
>
>
> i'm using
>
>    pg_ctl -l /var/log/pgsql/logfile start
>
> to start my postgres. So whenever i look at the log files i just
>
>    tail -f /var/log/pgsql/logfile
>
> that seems to do the trick.
>
>
> hope this helps,
>
>
> herbert


In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2001-09-27 14:13:48
Subject: Re: Finding active connections to postmaster
Previous:From: Martins ZarinsDate: 2001-09-27 09:35:55
Subject: Re: Finding active connections to postmaster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group