{ "info": { "author": "Fran\u00e7ois Pietka", "author_email": "francois@pietka.fr", "bugtrack_url": null, "classifiers": [ "Environment :: Console", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6" ], "description": ".. image:: https://landscape.io/github/fpietka/rds-pgbadger/master/landscape.svg?style=flat\n :target: https://landscape.io/github/fpietka/rds-pgbadger/master\n :alt: Code Health\n.. image:: https://img.shields.io/pypi/v/rdspgbadger.svg\n :target: https://pypi.python.org/pypi/rdspgbadger\n :alt: Version\n.. image:: https://img.shields.io/pypi/pyversions/rdspgbadger.svg\n :target: https://pypi.python.org/pypi/rdspgbadger\n :alt: Python versions supported\n.. image:: https://img.shields.io/pypi/l/rdspgbadger.svg\n :target: https://pypi.python.org/pypi/rdspgbadger\n :alt: License\n\n============\nRDS-pgBadger\n============\n\nFetches RDS log files and analyzes them with pgBadger_.\n\nPrerequisites\n-------------\n\nMake sure your credentials are set in the ``~/.aws/credentials`` file.\nAlso, you can set a region in the ``~/.aws/config`` file, so passing region option to the script is not needed.\nLast but not least, make sure you have ``pgbadger`` installed and reacheable from your ``$PATH``.\n\nParameter group\n---------------\n\nYou will have to configure your database parameter group.\n\nFirst of all, ensure ``log_min_duration_statement`` is set to ``0`` or higher, else you won't have anything to be parsed.\n\nThen you must enable some other parameters to get more information in the logs.\n\n+-----------------------------+-------+\n| Parameter | Value |\n+=============================+=======+\n| log_checkpoints | 1 |\n+-----------------------------+-------+\n| log_connections | 1 |\n+-----------------------------+-------+\n| log_disconnections | 1 |\n+-----------------------------+-------+\n| log_lock_waits | 1 |\n+-----------------------------+-------+\n| log_temp_files | 0 |\n+-----------------------------+-------+\n| log_autovacuum_min_duration | 0 |\n+-----------------------------+-------+\n\nAlso make sure ``lc_messages`` is either at engine default or set to ``C``.\n\nFor further details, please refer to Dalibo's pgBadger_ documentation.\n\nInstallation\n------------\n\nYou can install it using ``pip``::\n\n $ pip install rdspgbadger\n\nUsage\n-----\n\nTo build a ``pgbadger`` report, just run the following (replacing ``instanceid`` by your instance ID)::\n\n $ rds-pgbadger instanceid\n\nOptions\n-------\n\nOnly the Instance ID is mandatory, but there are also other options you can use:\n\n* -d, --date : by default the script downloads all the available logs. By specifying a date in the format ``YYYY-MM-DD``, you can then download only that day's logs.\n* -r, --region : by default the script use the region specified in your AWS config file. If none, or if you wish to change it, you can use this option to do so.\n* -o, --output : by default the script outputs log files and reports to the ``out`` folder. This option allows you to change it.\n* -n, --no-process : download log file(s), but do not process them with pgBadger.\n* -X, --pgbadger-args : command-line arguments to pass to pgBadger\n* --assume-role : By specifying a role you can use STS to assume a role, which is useful for cross account access with out having to setup the `.config` file. Format ``arn:aws:iam:::``\n\nKnown issue\n-----------\n\nIn spite of the great work of askainet_, AWS API seems to be too instable, and sometimes download of big log files can\nfail. In such case retrying a few minutes later seems to work.\n\nsee `pull request 10`_\n\nContribute\n----------\n\nFor any request, feel free to make a pull request or fill an issue on Github_.\n\n.. _pgBadger: http://dalibo.github.io/pgbadger/\n.. _Github: https://github.com/fpietka/rds-pgbadger\n.. _askainet: https://github.com/askainet\n.. _pull request 10: https://github.com/fpietka/rds-pgbadger/pull/10", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://github.com/fpietka/rds-pgbadger", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "rdspgbadger", "package_url": "https://pypi.org/project/rdspgbadger/", "platform": "", "project_url": "https://pypi.org/project/rdspgbadger/", "project_urls": { "Homepage": "http://github.com/fpietka/rds-pgbadger" }, "release_url": "https://pypi.org/project/rdspgbadger/1.2.2/", "requires_dist": null, "requires_python": "", "summary": "Fetch logs from RDS postgres instance and use them with pgbadger to generate a report.", "version": "1.2.2" }, "last_serial": 3606712, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "d9047ad2381696d43bdfce7c47a95657", "sha256": "e03076ef911f004c1dcfeb5c3daba76a0f7e8a84df8eb4ab8f1e030cd52b4449" }, "downloads": -1, "filename": "rdspgbadger-1.0.0.tar.gz", "has_sig": false, "md5_digest": "d9047ad2381696d43bdfce7c47a95657", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4809, "upload_time": "2016-10-13T19:39:53", "url": "https://files.pythonhosted.org/packages/1e/02/ffa2d8022fbfa4c523ef468b8f24e100675d4ced4a064267e3fbd194de91/rdspgbadger-1.0.0.tar.gz" } ], "1.0.1": [ { "comment_text": "", "digests": { "md5": "6eadcb34074409b92928e160b957b4a4", "sha256": "9d2440e08f99ecf5e531fe59e53b894c5d535365ef688cb0280a5c7dd02be813" }, "downloads": -1, "filename": "rdspgbadger-1.0.1.tar.gz", "has_sig": false, "md5_digest": "6eadcb34074409b92928e160b957b4a4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4965, "upload_time": "2016-10-25T16:46:45", "url": "https://files.pythonhosted.org/packages/86/30/d7899b7c806de9d302f7639d7aae142e8f6d1e4f6f1664d42367ab072c11/rdspgbadger-1.0.1.tar.gz" } ], "1.0.2": [ { "comment_text": "", "digests": { "md5": "78666919f001bef473b7e80e1920c127", "sha256": "5cede40d7a1d2212575855499af7050a75f050595dcce273ded9c42bcad8e39a" }, "downloads": -1, "filename": "rdspgbadger-1.0.2.tar.gz", "has_sig": false, "md5_digest": "78666919f001bef473b7e80e1920c127", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5360, "upload_time": "2016-11-01T22:12:51", "url": "https://files.pythonhosted.org/packages/37/2a/bf13ba40c0a0b0391a4a40203ba13d8c73719f6b0a8608815ae94b4ff812/rdspgbadger-1.0.2.tar.gz" } ], "1.0.3": [ { "comment_text": "", "digests": { "md5": "9116f737bf83b2189965cc8ba1a247dd", "sha256": "ce7305fee0f15cb322db42d6eab1f912b39b173eadc01b041c69f045e92f92ac" }, "downloads": -1, "filename": "rdspgbadger-1.0.3.tar.gz", "has_sig": false, "md5_digest": "9116f737bf83b2189965cc8ba1a247dd", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5368, "upload_time": "2016-11-04T17:23:23", "url": "https://files.pythonhosted.org/packages/29/11/132c6f4b8fd34f3d3ca05255df0289db6de09237f8c8f835fe9ce59d560c/rdspgbadger-1.0.3.tar.gz" } ], "1.1.0": [ { "comment_text": "", "digests": { "md5": "64cbcac3b7a169e3410fc6ddee268d1a", "sha256": "ebd5a3a614eda721f7ec7b8d74459be4a504a2fe5aab680f4ffa7065088b83ab" }, "downloads": -1, "filename": "rdspgbadger-1.1.0.tar.gz", "has_sig": false, "md5_digest": "64cbcac3b7a169e3410fc6ddee268d1a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5490, "upload_time": "2017-06-16T22:01:45", "url": "https://files.pythonhosted.org/packages/da/cb/03cdab3b4a300680dd5d51959489f6bd29dac5662c0afaf54217f5bf222c/rdspgbadger-1.1.0.tar.gz" } ], "1.2.0": [ { "comment_text": "", "digests": { "md5": "9d060de7f0e70329d1401157495b4f5e", "sha256": "b57ace1eb06ef8bb0b9b888b33b249d9c046a67069b9747e126f054a87f599bd" }, "downloads": -1, "filename": "rdspgbadger-1.2.0.tar.gz", "has_sig": false, "md5_digest": "9d060de7f0e70329d1401157495b4f5e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5529, "upload_time": "2017-10-22T09:22:39", "url": "https://files.pythonhosted.org/packages/b6/64/4608924d01218fbc4861c50437bb898319a364abe07a4ef65fa7da53eb1b/rdspgbadger-1.2.0.tar.gz" } ], "1.2.1": [ { "comment_text": "", "digests": { "md5": "bc9fe4473a1472046613285e65156bc9", "sha256": "1e5c2dc64bfd82420b3c2f050c199b6a7cf84911db4ae70d6c82e0e37c26ce9e" }, "downloads": -1, "filename": "rdspgbadger-1.2.1.tar.gz", "has_sig": false, "md5_digest": "bc9fe4473a1472046613285e65156bc9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5870, "upload_time": "2017-11-01T17:15:53", "url": "https://files.pythonhosted.org/packages/e0/e6/26b0fdca1cd53c6e46d4b1431679eeb208b5e8957b1a16b44e1c57e8e0fc/rdspgbadger-1.2.1.tar.gz" } ], "1.2.2": [ { "comment_text": "", "digests": { "md5": "11fca283e1150d25a4f72c51ca3a2f9c", "sha256": "4d9550111526cd6d89e61a6f14f8dd52f71a790e75d63a3f5cd0b7cb82ea04c5" }, "downloads": -1, "filename": "rdspgbadger-1.2.2.tar.gz", "has_sig": false, "md5_digest": "11fca283e1150d25a4f72c51ca3a2f9c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6351, "upload_time": "2018-02-22T20:47:32", "url": "https://files.pythonhosted.org/packages/e7/77/119de1625f6337f6759929a7f41f44c41b1b2292902012bbbfa789c37ec4/rdspgbadger-1.2.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "11fca283e1150d25a4f72c51ca3a2f9c", "sha256": "4d9550111526cd6d89e61a6f14f8dd52f71a790e75d63a3f5cd0b7cb82ea04c5" }, "downloads": -1, "filename": "rdspgbadger-1.2.2.tar.gz", "has_sig": false, "md5_digest": "11fca283e1150d25a4f72c51ca3a2f9c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6351, "upload_time": "2018-02-22T20:47:32", "url": "https://files.pythonhosted.org/packages/e7/77/119de1625f6337f6759929a7f41f44c41b1b2292902012bbbfa789c37ec4/rdspgbadger-1.2.2.tar.gz" } ] }