wal_sender_timeout default

https://www.postgresql.org/docs/11/runtime-config-replication.html

On 5/7/20 8:56 AM, Jasen Lentz wrote:

In Postgres 11.6-2, what is the default timeout for wal_sender_timeout
if it is commented out?

Form postgresql.conf

# The commented-out settings shown in this file represent the default
values.
# Re-commenting a setting is NOT sufficient to revert it to the default
value;
# you need to reload the server.

...

#wal_sender_timeout = 60s # in milliseconds; 0 disables

Jasen M. Lentz, M.Ed

Lead Systems Administrator

Sesco Enterprises, LLC

4977 State Route 30 East (Mailing Address Only)
Greensburg, PA 15601

W:� (724) 837-1991 x207

C:� (412) 848-5612

--
Adrian Klaver
adrian.klaver@aklaver.com

On Thu, May 7, 2020 at 8:56 AM Jasen Lentz <jlentz@sescollc.com> wrote:

In Postgres 11.6-2, what is the default timeout for wal_sender_timeout if
it is commented out?

The same value you would get if you uncommented the commented out setting...

Also the value you would get by querying the database while the setting is
commented out (assuming it isn't being set elsewhere).

show wal_sender_timeout;
select * from pg_settings where name = 'wal_sender_timeout';

Its also the value that the documentation says is the default value.

https://www.postgresql.org/docs/12/runtime-config-replication.html#RUNTIME-CONFIG-REPLICATION-SENDER

David J.

On 5/7/20 9:07 AM, Adrian Klaver wrote:

On 5/7/20 8:56 AM, Jasen Lentz wrote:

In Postgres 11.6-2, what is the default timeout for wal_sender_timeout
if it is commented out?

Form postgresql.conf

Oops, from.

# The commented-out settings shown in this file represent the default
values.
# Re-commenting a setting is NOT sufficient to revert it to the default
value;
# you need to reload the server.

...

#wal_sender_timeout = 60s������ # in milliseconds; 0 disables

Realized that the comment maybe confusing. If you just include an
integer it will be in milliseconds. Including a time unit s(econds)
overrides that.

Jasen M. Lentz, M.Ed

Lead Systems Administrator

Sesco Enterprises, LLC

4977 State Route 30 East (Mailing Address Only)
Greensburg, PA 15601

W:� (724) 837-1991 x207

C:� (412) 848-5612

--
Adrian Klaver
adrian.klaver@aklaver.com