How to install gpperfmon when using the "Greenplum Database Ubuntu Distribution"

[Bill Bailey]

Hi All,  I'm a new Greenplum users and thanks in advance for any help and advice......

I've installed Greenplum OSS using the distributed Ubuntu binaries https://greenplum.org/install-greenplum-oss-on-ubuntu/ and want to set up the gpperfmon database

It appears that the gpperfmon_install command-line utility is not contained within the Ubuntu package

Is there any way to manually install it or do I have to compile the complete system from source instead of using the distribution ?

[Ivan Novick]

Hi Bill,

You can enable it manually, but it would be good to file a github issue for the missing utility.

Here is the code excerpt from gpperfmon_install, you can see it is just automating a series of manual steps:

    cmd = Command("createdb gpperfmon")
    cmd = Command("PGPORT=%d psql -f %s/lib/gpperfmon/gpperfmon.sql gpperfmon" % (options.port, gphome))

        cmd = Command("""PGPORT=%d psql template1 -c "DROP ROLE IF EXISTS gpmon" """ % options.port)
        cmd = Command("""PGPORT=%d psql template1 -c "CREATE ROLE gpmon WITH SUPERUSER CREATEDB LOGIN ENCRYPTED PASSWORD '%s'" """ % (options.port, options.password))

        cmd = Command("""echo "local    gpperfmon         gpmon         md5" >> %s""" % pg_hba, showOutput=True)
        cmd = Command("""echo "host     all         gpmon         127.0.0.1/28    md5" >> %s""" % pg_hba, showOutput=True)
        cmd = Command("""echo "host     all         gpmon         ::1/128    md5" >> %s""" % pg_hba, showOutput=True)

        ################################################
        # these commands add a new line to the top of .pgpass and save a copy of old .pgpass
        cmd = Command("""touch %s""" % (pg_pass))
        cmd = Command("""mv -f %s %s""" % (pg_pass, old_pg_pass))
        cmd = Command("""echo "*:%d:gpperfmon:gpmon:%s" >> %s""" % (options.port, options.password, pg_pass), showOutput=True)
        cmd = Command("""cat %s >> %s""" % (old_pg_pass, pg_pass), showOutput=True)
        cmd = Command("""chmod 0600 %s""" % pg_pass)
        ################################################
        cmd = Command("PGPORT=%d gpconfig -c gp_enable_gpperfmon -v on" % (options.port))
        cmd = Command("PGPORT=%d gpconfig -c gpperfmon_port -v %d" % (options.port, options.gpperfmonport))
        cmd = Command("PGPORT=%d gpconfig -c gp_external_enable_exec -v on --masteronly" % (options.port))
        cmd = Command("PGPORT=%d gpconfig -c gpperfmon_log_alert_level -v warning" % (options.port))

Cheers,

Ivan

***** Email confidentiality notice *****

Xanadu Consultancy Limited is a limited company registered in Ireland with registered number 500416 and VAT registered number IE 9793319P. Our registered office is at Floor 2, River House, Blackpool Retail & Business Park, Cork, Ireland. We have a branch office registered in England and Wales with company number FC030315, whose address is at Unit 710 Highgate Studios, 53-79 Highgate Road, London, NW5 1TL.

This message is intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to us, and immediately and permanently delete it. Do not use, copy or disclose the information contained in this message or in any attachment. Xanadu Consultancy Limited cannot accept liability for any statements made which are clearly the sender’s own and not expressly made on behalf of Xanadu Consultancy Limited.

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+unsubscribe@greenplum.org.
To post to this group, send email to gpdb-...@greenplum.org.
Visit this group at https://groups.google.com/a/greenplum.org/group/gpdb-users/.
For more options, visit https://groups.google.com/a/greenplum.org/d/optout.

--

Ivan Novick, Product Manager Pivotal Greenplum

ino...@pivotal.io --  (Mobile) 408-230-6491

https://www.youtube.com/GreenplumDatabase

[Bill Bailey]

Done - https://github.com/greenplum-db/gpdb/issues/4513

To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.

To post to this group, send email to gpdb-...@greenplum.org.
Visit this group at https://groups.google.com/a/greenplum.org/group/gpdb-users/.
For more options, visit https://groups.google.com/a/greenplum.org/d/optout.