Re: Permissions to connect to postgres database
| От | Shoaib Mir |
|---|---|
| Тема | Re: Permissions to connect to postgres database |
| Дата | |
| Msg-id | bf54be870607271417u75f556e8s42c60bac9eaeda7e@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Permissions to connect to postgres database (Richard Huxton <dev@archonet.com>) |
| Список | pgsql-general |
You can turn on connection logging by setting the following in postgresql.conf file:
log_connections = on
log_disconnections = on
and this will log all the connections and disconnections to your database server in the db server log files.
Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
log_connections = on
log_disconnections = on
and this will log all the connections and disconnections to your database server in the db server log files.
Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 7/27/06, Richard Huxton < dev@archonet.com> wrote:
Jasbinder Bali wrote:
> How do i turn on the connection logging and then how do you actually check
> it?
Log settings are in your postgresql.conf file and are detailed in this
part of the manual:
http://www.postgresql.org/docs/8.1/static/runtime-config-logging.html
Where your logfiles are stored will depend on your settings, but
typically on a unix-style system they will be in /var/log/.
I recommend you stop what you're doing for an hour or two and quickly
read through section III (Server Administration) of the manuals. That
will save you a lot of time later.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
В списке pgsql-general по дате отправления: