Re: turning on debug without restarting postgres

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@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Herbert Rabago Ambos
> Sent: Friday, September 28, 2001 7:12 AM
> To: Rainer Mager
> Cc: pgsql-admin@postgresql.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