notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)Want a good monitor light? See my photosAll times are UTC		 Ukraine
I started running short on disk space for the non-production FreshPorts hosts. This time, I have decided to ask for donations. See my recent blog post which points to my Patreon account.
Port details
pgschema Terraform-style declarative schema migration workflow for Postgres
1.1.0_1 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 1.1.0Version of this port present on the latest quarterly branch.
Maintainer: olgeni@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2025-09-22 08:54:12
Last Update: 2025-10-08 00:41:39
Commit Hash: 2e7587a
License: PGSCHEMA
WWW:
https://github.com/pgschema/pgschema
Description:
pgschema is a Terraform-style, declarative schema migration workflow for PostgreSQL databases. It enables you to manage database schema changes through code with a declarative approach that tracks schema state and applies only necessary changes. Key features: - Declarative schema management similar to Terraform - Supports PostgreSQL versions 14, 15, 16, and 17 - Tracks schema state and applies incremental changes - Provides table creation with LIKE syntax - Clean, code-driven database migration workflow
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (4 items)
Collapse this list.
  1. bin/pgschema
  2. /usr/local/share/licenses/pgschema-1.1.0_1/catalog.mk
  3. /usr/local/share/licenses/pgschema-1.1.0_1/LICENSE
  4. /usr/local/share/licenses/pgschema-1.1.0_1/PGSCHEMA
Collapse this list.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • pgschema>0:databases/pgschema
To install the port:
cd /usr/ports/databases/pgschema/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pgschema
  • pkg install pgschema
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: pgschema
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1758618838 SHA256 (go/databases_pgschema/pgschema-v1.1.0/v1.1.0.mod) = 02d936b8e6e16e2e81ac29e3e6c0b370fd62e023a09eb00de0dbf65d30a5e166 SIZE (go/databases_pgschema/pgschema-v1.1.0/v1.1.0.mod) = 3456

Expand this list (2 items)

Collapse this list.

SHA256 (go/databases_pgschema/pgschema-v1.1.0/v1.1.0.zip) = dc11b267f261a43ec3912ec8c9a5565d646f6f922a4befd73e57449b728dbd10 SIZE (go/databases_pgschema/pgschema-v1.1.0/v1.1.0.zip) = 1100072

Collapse this list.

Packages (timestamps in pop-ups are UTC):
pgschema
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest1.1.01.1.0-1.1.01.1.0---
FreeBSD:13:quarterly-1.1.0--1.1.0---
FreeBSD:14:latest-1.1.0--1.1.0---
FreeBSD:14:quarterly-1.1.0--1.1.0---
FreeBSD:15:latest1.1.01.1.0n/a-n/a---
FreeBSD:15:quarterly--n/a-n/a---
FreeBSD:16:latest-1.1.0n/a-n/a---
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. go124 : lang/go124
Fetch dependencies:
  1. go124 : lang/go124
There are no ports dependent upon this port
Configuration Options:
No options to configure
Options name:
databases_pgschema
USES:
go:1.24,modules zip
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://proxy.golang.org/github.com/pgschema/pgschema/@v/
Collapse this list.

Number of commits found: 3

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
1.1.0_1
08 Oct 2025 00:41:39
commit hash: 2e7587aaf8e7f893fd2025d55f66de088427b180commit hash: 2e7587aaf8e7f893fd2025d55f66de088427b180commit hash: 2e7587aaf8e7f893fd2025d55f66de088427b180commit hash: 2e7587aaf8e7f893fd2025d55f66de088427b180 files touched by this commit		 Adam Weinberger (adamw) search for other commits by this committer 
many: Bump dependent ports after go124 update
1.1.0
23 Sep 2025 15:37:46
commit hash: 6b54d25fc12af40b7078df9afc8a07ad7a191cf5commit hash: 6b54d25fc12af40b7078df9afc8a07ad7a191cf5commit hash: 6b54d25fc12af40b7078df9afc8a07ad7a191cf5commit hash: 6b54d25fc12af40b7078df9afc8a07ad7a191cf5 files touched by this commit		 Jimmy Olgeni (olgeni) search for other commits by this committer 
databases/pgschema: Update to 1.1.0
1.0.3
22 Sep 2025 08:51:42
commit hash: ae09fb5df8897284dae4e15a8591200a18aebf5ccommit hash: ae09fb5df8897284dae4e15a8591200a18aebf5ccommit hash: ae09fb5df8897284dae4e15a8591200a18aebf5ccommit hash: ae09fb5df8897284dae4e15a8591200a18aebf5c files touched by this commit		 Jimmy Olgeni (olgeni) search for other commits by this committer 
databases/pgschema: Add new port

pgschema is a Terraform-style, declarative schema migration workflow for
PostgreSQL databases. It enables you to manage database schema changes
through code with a declarative approach that tracks schema state and applies
only necessary changes.

Supports PostgreSQL versions 14, 15, 16, and 17.

WWW: https://github.com/pgschema/pgschema

Number of commits found: 3
Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
Security Policy
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
mailpitOct 09
firefoxOct 07
firefoxOct 07
firefox-esrOct 07
mongodb60*Oct 07
mongodb70*Oct 07
thunderbirdOct 07
thunderbirdOct 07
firefoxOct 06
firefox-esrOct 06
mongodb60Oct 06
mongodb60Oct 06
mongodb70Oct 06
mongodb70Oct 06
mongodb80Oct 06

25 vulnerabilities affecting 341 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2025-10-09 11:16:17 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 33754
Broken 125
Deprecated 214
Ignore 244
Forbidden 0
Restricted 2
No CDROM 1
Vulnerable 37
Expired 10
Set to expire 160
Interactive 0
new 24 hours 7
new 48 hours12
new 7 days46
new fortnight105
new month175
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2025 Dan Langille. All rights reserved.