Re: [NOVICE] NOVICE log on - Mailing list pgsql-novice

From Tom Lane
Subject Re: [NOVICE] NOVICE log on
Date
Msg-id 11468.1496798465@sss.pgh.pa.us
Whole thread Raw
In response to [NOVICE] NOVICE log on  (Mike Rowan <michael.rowan3@gmail.com>)
List pgsql-novice
Mike Rowan <michael.rowan3@gmail.com> writes:
> A very very basic question...
> Is there, in PostgreSQL 9.1 preferably, a log of logon attempts and the
> reason for failure, if any.

Look into the postmaster log file.  If you're not sure where that is,
checking the settings described in
https://www.postgresql.org/docs/9.1/static/runtime-config-logging.html
should help.

You might care to enable log_connections to help debug your problem,
but I believe connection rejections would be logged in any case.

            regards, tom lane


pgsql-novice by date:

Previous
From: Mike Rowan
Date:
Subject: [NOVICE] NOVICE log on
Next
From: "David G. Johnston"
Date:
Subject: Re: [NOVICE] NOVICE log on