Home > mailing lists

Thread: Tool for comparing parameters

Tool for comparing parameters

From

bhargav kamineni

Date:

24 October 2018, 17:30:36

Hi Team,

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

Thanks

Bhargav K

Re: Tool for comparing parameters

From

Thomas Kellerer

Date:

24 October 2018, 17:40:37

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

From

Rahul Saha

Date:

24 October 2018, 17:42:30

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