PHPackages                             dbmover/pgsql - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. dbmover/pgsql

ActiveLibrary

dbmover/pgsql
=============

PostgreSQL vendor-specific DbMover module

0.10.5(1y ago)1328↓100%[2 PRs](https://github.com/dbmover/pgsql/pulls)MITPHPPHP &gt;=7.3

Since Jul 15Pushed 1y ago1 watchersCompare

[ Source](https://github.com/dbmover/pgsql)[ Packagist](https://packagist.org/packages/dbmover/pgsql)[ RSS](/packages/dbmover-pgsql/feed)WikiDiscussions master Synced today

READMEChangelogDependencies (3)Versions (33)Used By (0)

DbMover/PgSQL
=============

[](#dbmoverpgsql)

PostgreSQL vendor-specific metapackage for DbMover

Installation
------------

[](#installation)

### Composer (recommended)

[](#composer-recommended)

```
$ composer require dbmover/pgsql
```

Setup and running
-----------------

[](#setup-and-running)

See [the Dbmover README](http://dbmover.monomelodies.nl/core/docs/) for instructions on setting up and running DbMover.

Add the `Dbmover\Pgsql\Plugin` meta-plugin to simply use the defaults.

PostgreSQL specific notes
-------------------------

[](#postgresql-specific-notes)

### Serial primary keys

[](#serial-primary-keys)

PostgreSQL uses the custom `SERIAL` datatype for defining an auto-incrementing unique column to be used as a primary key. However, this is not an *actual* datatype but rather shorthand for a more verbose manual command. So (unsurprisingly) DbMover doesn't know what to do with it. Write the more verbose full commands instead:

```
CREATE SEQUENCE IF NOT EXISTS foo_id_seq;
CREATE TABLE foo (
    id INTEGER NOT NULL PRIMARY KEY DEFAULT NEXTVAL('foo_id_seq'::regclass)
);
```

### Database users and privileges

[](#database-users-and-privileges)

PostgreSQL's `INFORMATION_SCHEMA` aliases contain more data than you would define in a schema file, especially for routines (its native functions are also exposed there). You should always run DbMover as a user with privileges for only the database being migrated. All plugins try their best to only work on objects defined as `public`, but better safe than sorry.

TODO/wishlist
-------------

[](#todowishlist)

### Support for enums

[](#support-for-enums)

These are implemented in Postgres as a sort of custom data types. Support is on the roadmap, but since I personally never use them it's not *very* high on my (annoyingly long) list of priorities :)

###  Health Score

35

—

LowBetter than 81% of packages

Maintenance47

Moderate activity, may be stable

Popularity14

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity59

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~112 days

Recently: every ~478 days

Total

29

Last Release

389d ago

PHP version history (2 changes)0.7.0PHP &gt;=7.2

0.9.1PHP &gt;=7.3

### Community

Maintainers

![](https://www.gravatar.com/avatar/bce0289662bc7c78014afb3610eb7558b68948a97cb2f9b0efd1755d80dc7c2a?d=identicon)[monomelodies](/maintainers/monomelodies)

---

Top Contributors

[![monomelodies](https://avatars.githubusercontent.com/u/260346?v=4)](https://github.com/monomelodies "monomelodies (144 commits)")

### Embed Badge

![Health badge](/badges/dbmover-pgsql/health.svg)

```
[![Health](https://phpackages.com/badges/dbmover-pgsql/health.svg)](https://phpackages.com/packages/dbmover-pgsql)
```

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)
