postgresql_info: provide pg_is_in_recovery()

[phemmer]

SUMMARY

The postgresql_info module should provide a variable containing the result of select pg_is_in_recovery().

ISSUE TYPE

• Feature Idea

COMPONENT NAME

I think it would make sense to put the value in the top level of the returned dict as is_in_recovery.

ADDITIONAL INFORMATION

This feature would allow the user to determine whether postgres is running as a replica slave, or standalone/master, and be able to skip tasks when so. This is important as when running tasks which update the database, you can only make changes to a master, and the changes then get replicated to the slave(s).

Could also be used in a loop when waiting for a restored database to finish start up.

[ansibullbot]

Files identified in the description:
None

If these files are inaccurate, please update the component name section of the description or use the !component bot command.

click here for bot help

[kostiantyn-nemchenko]

!component =plugins/modules/database/postgresql/postgresql_info.py

[ansibullbot]

Files identified in the description:

• plugins/modules/database/postgresql/postgresql_info.py

If these files are inaccurate, please update the component name section of the description or use the !component bot command.

click here for bot help

[ansibullbot]

cc @Andersson007 @Dorn- @andytom @ilicmilan @jbscalia @matburt @nerzhul @sebasmannem @tcraxs
click here for bot help

[Andersson007]

@phemmer hi, thanks for the feedback! Sounds good.
If anybody wants to add the feature, i'd be happy to review (if yes, please, before you start, put a comment here)

[Andersson007]

I'm working on this

[Andersson007]

Done #1091
@phemmer could you please take a look? If this is ok for you please put shipit there (in the PR).

[phemmer]

That was fast. Probably would have gotten to it myself eventually, but who knows when that would have been :-)
Thanks!

[Andersson007]

@phemmer thanks for the idea!

Next community.general release will be ~at the end of November, so you can install the collection from galaxy and use then.