{"repo":"phillbaker/pg_migrate","free":true,"listed":false,"github":"https://github.com/phillbaker/pg_migrate","clone":"git clone https://github.com/phillbaker/pg_migrate.git","description":"Reorganize tables in PostgreSQL databases with minimal locks","language":"C","stars":16,"topics":["postgresql","postgres","pg","migrations"],"license":"BSD-3-Clause","category":"databases-storage","readme_excerpt":"pg migrate -- Perform schema changes in PostgreSQL with minimal locks - Download: https://github.com/phillbaker/pg migrate/releases - Development: https://github.com/phillbaker/pg migrate - Bug Reports: https://github.com/phillbaker/pg migrate/issues About pg migrate is a PostgreSQL extension and CLI which lets you make schema changes to tables and indexes. Unlike ALTER TABLE it works online, without holding a long lived exclusive lock on the processed tables during the migration. It builds a copy of the target table and swaps them. Please check the documentation (in the doc directory or online) for installation and usage instructions. Forked from the excellent pg repack project (https://reorg.github.io/pg repack). Supported Postgres Versions Postgres = 9.6 Installation Ubuntu/Debian Use apt-get to install the package matching the Postgres version ( postgresql- -pg migrate ) being run from this repo's APT repository. To add to your /etc/apt/sources.list.d , add the signing GPG key, and update the package DB, run: Then to install, for example, for Postgres 10: Load the pg migrate Postgres extension in the database you want to work on: Mac Use homebrew to install the package matching the Postgres version being used. Examples Change the type of a column Add a column with a default (non-nullable) Known Limitations Unique constraints are converted into unique indexes, they are equivalent in Postgres. However, this may be an unexpected change. Index names on the target table and fo","default_branch":null,"files":null,"tree":[],"storefront":"/r/phillbaker","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/phillbaker/pg_migrate/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}