Обсуждение: wal_sender_timeout default

Поиск
Список
Период
Сортировка

wal_sender_timeout default

От
Jasen Lentz
Дата:

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

 

 

Вложения

Re: wal_sender_timeout default

От
Michael Lewis
Дата:

Re: wal_sender_timeout default

От
Adrian Klaver
Дата:
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

От
"David G. Johnston"
Дата:
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

От
Adrian Klaver
Дата:
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