Postgres Pro
Downloads
Home   >   mailing lists

Thread: wal_sender_timeout default

wal_sender_timeout default

From
Jasen Lentz
Date:

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

 

 

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

 

 

Attachment

Re: wal_sender_timeout default

From
Michael Lewis
Date:

Re: wal_sender_timeout default

From
Adrian Klaver
Date:
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

Re: wal_sender_timeout default

From
"David G. Johnston"
Date:
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.

Re: wal_sender_timeout default

From
Adrian Klaver
Date:
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