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)

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 по дате отправления:

Предыдущее
От: Ken Johanson
Дата:
Сообщение: Re: Backslash as ordinary char vs. not; set via a connection/session
Следующее
От: "Shoaib Mir"
Дата:
Сообщение: Re: server administration problem: Database startup and permissions