{ "info": { "author": "Marti Raudsepp", "author_email": "marti@voicecom.ee", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Environment :: Console", "Intended Audience :: Developers", "Intended Audience :: System Administrators", "License :: OSI Approved :: Apache Software License", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Topic :: Database :: Front-Ends", "Topic :: System :: Systems Administration" ], "description": "PGtool\n======\n.. image:: https://badge.fury.io/py/pgtool.svg\n :target: http://badge.fury.io/py/pgtool\n\n.. image:: https://travis-ci.org/voicecom/pgtool.svg?branch=master\n :alt: Travis CI\n :target: http://travis-ci.org/voicecom/pgtool\n\nPGtool is a command-line tool designed to simplify some common maintenance tasks on PostgreSQL databases. It works with\nPython 2.7 and 3.3+ using the psycopg2 driver.\n\nAvailable commands:\n\ncp SOURCE DEST\n Uses CREATE DATABASE ... TEMPLATE to create a duplicate of a database. Additionally copies over database-specific\n settings.\n\n When used with --force, an existing database with the same name as DEST is replaced, the original is renamed out of\n place in the form DEST_old_YYYYMMDD (unless --no-backup is specified).\n\nmv SOURCE DEST\n Rename a database within a server.\n\n When used with --force, an existing database with the same name as DEST is replaced, the original is renamed out of\n place in the form DEST_old_YYYYMMDD (unless --no-backup is specified).\n\nkill DBNAME [DBNAME ...]\n Kills all active connections to the specified database(s).\n\nreindex IDXNAME [IDXNAME ...]\n Uses CREATE INDEX CONCURRENTLY to create a duplicate index, then tries to swap the new index for the original.\n\n The index swap is done using a short lock timeout to prevent it from interfering with running queries. Retries until\n the rename succeeds.\n\nResources\n---------\n\n* https://github.com/voicecom/pgtool\n* https://pypi.python.org/pypi/pgtool\n\nChangelog\n---------\n\n0.0.1 (2015-10-26)\n\n* Initial public release, commands: 'cp', 'mv', 'kill' & 'reindex'\n\nContributing\n------------\n\nCode style:\n\n* In general follow the Python PEP-8_ coding style, except line length can go up to 120 chars.\n* Strings that have meaning for humans use double quotes (``\"``), otherwise single quotes (``'``). When in doubt, don't\n worry about it.\n* Code should be compatible with both Python 2 and 3, preferably without version-specific conditionals.\n\nRun the test suite using ``python setup.py test``.\n\nSubmit your changes as pull requests on GitHub.\n\n.. _PEP-8: https://www.python.org/dev/peps/pep-0008/\n\nLicense\n-------\n\nCopyright 2015 Voicecom, Marti Raudsepp & contributors\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this file except in compliance with the License.\nYou may obtain a copy of the License at\n\n https://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.", "description_content_type": null, "docs_url": null, "download_url": "https://pypi.python.org/pypi/pgtool/", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/voicecom/pgtool", "keywords": "postgresql tool maintenance admin reindex concurrently rename move copy duplicate databases voicecom", "license": "Apache Software License", "maintainer": null, "maintainer_email": null, "name": "pgtool", "package_url": "https://pypi.org/project/pgtool/", "platform": "any", "project_url": "https://pypi.org/project/pgtool/", "project_urls": { "Download": "https://pypi.python.org/pypi/pgtool/", "Homepage": "https://github.com/voicecom/pgtool" }, "release_url": "https://pypi.org/project/pgtool/0.0.1/", "requires_dist": null, "requires_python": null, "summary": "Command-line tool to simplify some common maintenance tasks on PostgreSQL databases", "version": "0.0.1" }, "last_serial": 1786455, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "eac704a8cfb4f21ec079a16d6f894aca", "sha256": "f6f0c8716b95634e1d0a2e5bf48de5e5aea68b1b0d8ac66ea0a6e1b6d28fb925" }, "downloads": -1, "filename": "pgtool-0.0.1.tar.gz", "has_sig": false, "md5_digest": "eac704a8cfb4f21ec079a16d6f894aca", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7646, "upload_time": "2015-10-26T11:45:51", "url": "https://files.pythonhosted.org/packages/48/23/410c484407fee9dc1101481e3c185188c28846fa724c8629f1b88f1be0ad/pgtool-0.0.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "eac704a8cfb4f21ec079a16d6f894aca", "sha256": "f6f0c8716b95634e1d0a2e5bf48de5e5aea68b1b0d8ac66ea0a6e1b6d28fb925" }, "downloads": -1, "filename": "pgtool-0.0.1.tar.gz", "has_sig": false, "md5_digest": "eac704a8cfb4f21ec079a16d6f894aca", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7646, "upload_time": "2015-10-26T11:45:51", "url": "https://files.pythonhosted.org/packages/48/23/410c484407fee9dc1101481e3c185188c28846fa724c8629f1b88f1be0ad/pgtool-0.0.1.tar.gz" } ] }