Tool for comparing parameters

Started by bhargav kamineniover 7 years ago3 messagesgeneral

Jump to latest

bhargav kamineni

bhargavpostgres@gmail.com

over 7 years ago

Hi Team,

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

Thanks
Bhargav K

Thomas Kellerer

spam_eater@gmx.net

over 7 years ago

In reply to: bhargav kamineni (#1)

Re: Tool for comparing parameters

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

Rahul Saha

rahul.blooming@gmail.com

over 7 years ago

In reply to: Thomas Kellerer (#2)

Re: Tool for comparing parameters

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