Re: tcp_keepalives settings not being set

Thank you!  That change allowed me to view those parameters.  I had no idea
i wasn't connecting via TCP.

Thanks again!

On Wed, Dec 4, 2019 at 9:54 AM Tom Lane <[email protected]> wrote:

> Dave Hughes <[email protected]> writes:
> > We have PostgreSQL 10.5 installed on RHEL 6 and I’m new to both.  I’m in
> > the process of completing STIGs (Security Technical Implementation
> Guides)
> > for the Department of Defense.  One of the STIGs mentions that we must
> > ensure our tcp_keepalives settings are configured in the postgresql.conf
> > file.  I currently have these settings set to:
> > Tcp_keepalives_idle = 60
> > Tcp_keepalives_interval = 60
> > Tcp_keepalives_count = 2
> > I restarted the database and then ran SHOW_ALL; but it showed all 3
> > parameters set to 0.
>
> These will read as zeroes if you're using a non-TCP connection (ie
> Unix socket).  Try it after "psql -h localhost" instead of just "psql".
>
>                         regards, tom lane
>