Re: tcp_keepalives settings not being set

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Hughes <dhughes20(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: tcp_keepalives settings not being set
Date: 2019-12-04 14:54:10
Message-ID: 17947.1575471250@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dave Hughes <dhughes20(at)gmail(dot)com> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dave Hughes 2019-12-04 15:09:02 Re: tcp_keepalives settings not being set
Previous Message Dave Hughes 2019-12-04 14:33:50 tcp_keepalives settings not being set