Обсуждение: Tool for comparing parameters

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

Tool for comparing parameters

От
bhargav kamineni
Дата:
Hi Team,


Is there any opensource or paid tool  that compares postgresql database parameters? (NOT SCHEMA) .


Thanks 
Bhargav K

Re: Tool for comparing parameters

От
Thomas Kellerer
Дата:
bhargav kamineni schrieb am 24.10.2018 um 16:30:
> Is there any opensource or paid tool  that compares postgresql database parameters? (NOT SCHEMA) .

You could dump the content of pg_settings into CSV files (sorted by name) and then run a diff on both CSV files. 

Thomas

Re: Tool for comparing parameters

От
Rahul Saha
Дата:
Check_pgactivity plugin for Nagios can also compare if anyone change any settings. 

On Wed, 24 Oct 2018 at 8:11 PM, Thomas Kellerer <spam_eater@gmx.net> wrote:
bhargav kamineni schrieb am 24.10.2018 um 16:30:
> Is there any opensource or paid tool  that compares postgresql database parameters? (NOT SCHEMA) .

You could dump the content of pg_settings into CSV files (sorted by name) and then run a diff on both CSV files.

Thomas


--
Thanks & Regards
Rahul Saha

+91 8806351116

Sent from my iPhone