Reload vs online restart

[Harif-Rahman]

Can someone explain the difference between RELOAD command and online restart using -R in command line.

Since we deprecated the online restart are we suggesting to go with RELOAD option?

[Harif-Rahman]

Also i dont want to use so_reuseport option for now. in this case what is the recommendation to do hot reload without affecting existing connections?

[JelteF]

Using the RELOAD command is generally what you want to use for hot reload. There are a few settings that you cannot change with a hot reload and which require a restart instead. But there are very few.

[Harif-Rahman]

@JelteF
Can you give me the list of config parameter where the hot reload will not work ?

[JelteF]

the ones with CF_NO_RELOAD in this list: https://github.com/pgbouncer/pgbouncer/blob/master/src/main.c#L234-L330

[JelteF]

It would be good to actually list in the documentation which config parameters require a restart (probably for some that's already done).

[Harif-Rahman]

Thanks