NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit83d48a8

committed

Limit values of archive_timeout, post_auth_delay, auth_delay.milliseconds.

The previous definitions of these GUC variables allowed them to rangeup to INT_MAX, but in point of fact the underlying code would sufferoverflows or other errors with large values. Reduce the maximum valuesto something that won't misbehave. There's no apparent value in workingharder than this, since very large delays aren't sensible for any ofthese. (Note: the risk with archive_timeout is that if we're latechecking the state, the timestamp difference it's being compared tomight overflow. So we need some amount of slop; the choice of INT_MAX/2is arbitrary.)Per followup investigation of bug #7670. Although this isn't a verysignificant fix, might as well back-patch.

1 parent89067bc commit83d48a8Copy full SHA for 83d48a8

File tree

2 files changed

-3

lines changed

contrib/auth_delay
- auth_delay.c
src/backend/utils/misc
- guc.c

2 files changed

-3

lines changed

`‎contrib/auth_delay/auth_delay.c`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -59,7 +59,7 @@ _PG_init(void)`
`59`	`59`	`NULL,`
`60`	`60`	`&auth_delay_milliseconds,`
`61`	`61`	`0,`
`62`		`-0,INT_MAX,`
	`62`	`+0,INT_MAX /1000,`
`63`	`63`	`PGC_SIGHUP,`
`64`	`64`	`GUC_UNIT_MS,`
`65`	`65`	`NULL,`

`‎src/backend/utils/misc/guc.c`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1465,7 +1465,7 @@ static struct config_int ConfigureNamesInt[] =`
`1465`	`1465`	`GUC_UNIT_S`
`1466`	`1466`	`},`
`1467`	`1467`	`&XLogArchiveTimeout,`
`1468`		`-0,0,INT_MAX,`
	`1468`	`+0,0,INT_MAX /2,`
`1469`	`1469`	`NULL,NULL,NULL`
`1470`	`1470`	`},`
`1471`	`1471`	`{`
`@@ -1475,7 +1475,7 @@ static struct config_int ConfigureNamesInt[] =`
`1475`	`1475`	`GUC_NOT_IN_SAMPLE \|GUC_UNIT_S`
`1476`	`1476`	`},`
`1477`	`1477`	`&PostAuthDelay,`
`1478`		`-0,0,INT_MAX,`
	`1478`	`+0,0,INT_MAX /1000000,`
`1479`	`1479`	`NULL,NULL,NULL`
`1480`	`1480`	`},`
`1481`	`1481`	`{`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit83d48a8

File tree

2 files changed

2 files changed

`‎contrib/auth_delay/auth_delay.c`

`‎src/backend/utils/misc/guc.c`

0 commit comments