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
The recently imposed "must be logged in" restriction is a response to increased bot traffic on the site. This affects search, commits, and vuxml pages.
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
After the ports freeze to fix some stuff, the freeze is over. I have some work to do before FreshPorts can start processing commits again before it can start processing again. I've created an issue for that.
Port details
pgschema Terraform-style declarative schema migration workflow for Postgres
1.13.0 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.5.1_10Version 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: 2026-09-08 13:48:04
Commit Hash: 83d6ec9
License: PGSCHEMA
WWW:
https://github.com/pgplex/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.13.0/catalog.mk
  3. /usr/local/share/licenses/pgschema-1.13.0/LICENSE
  4. /usr/local/share/licenses/pgschema-1.13.0/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 = 1788858203 SHA256 (go/databases_pgschema/pgschema-v1.13.0/v1.13.0.mod) = 4227369cae6153d9b14a1ddba5ac4e291988e779718cff9fb058c8df81878b6f SIZE (go/databases_pgschema/pgschema-v1.13.0/v1.13.0.mod) = 1005

Expand this list (2 items)

Collapse this list.

SHA256 (go/databases_pgschema/pgschema-v1.13.0/v1.13.0.zip) = 54ddf5d307128c09e394d6d319f0481faabfd00afd83dc00b97abfb841df13e1 SIZE (go/databases_pgschema/pgschema-v1.13.0/v1.13.0.zip) = 2048664

Collapse this list.

Packages (timestamps in pop-ups are UTC):
pgschema
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest1.5.1_51.5.1_5n/an/an/an/an/an/a
FreeBSD:13:quarterly1.5.1_51.5.1_5n/an/an/an/an/an/a
FreeBSD:14:latest1.13.01.13.0--1.13.0---
FreeBSD:14:quarterly1.5.1_101.5.1_10--1.5.1_10---
FreeBSD:15:latest1.13.01.13.0n/a-n/an/a--
FreeBSD:15:quarterly1.5.1_101.5.1_10n/a-n/an/a--
FreeBSD:16:latest1.13.01.13.0n/a-n/an/a--
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. go126 : lang/go126
Fetch dependencies:
  1. go126 : lang/go126
There are no ports dependent upon this port
Configuration Options:
No options to configure
Options name:
databases_pgschema
USES:
go: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/pgplex/pgschema/@v/
Collapse this list.

Number of commits found: 22

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
1.13.0
08 Sep 2026 13:48:04
commit hash: 83d6ec9406588c71c3e828206132f7e8035ea45fcommit hash: 83d6ec9406588c71c3e828206132f7e8035ea45fcommit hash: 83d6ec9406588c71c3e828206132f7e8035ea45fcommit hash: 83d6ec9406588c71c3e828206132f7e8035ea45f files touched by this commit		 Jimmy Olgeni (olgeni) search for other commits by this committer 
databases/pgschema: Update to 1.13.0
1.12.5_1
03 Sep 2026 04:50:55
commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01 files touched by this commit		 Adam Weinberger (adamw) search for other commits by this committer 
many: Bump go ports for 1.26.8 and 1.27.1
1.12.5
31 Aug 2026 07:31:54
commit hash: 7314c09e87d4777f56df3a218dc8240bf65c6206commit hash: 7314c09e87d4777f56df3a218dc8240bf65c6206commit hash: 7314c09e87d4777f56df3a218dc8240bf65c6206commit hash: 7314c09e87d4777f56df3a218dc8240bf65c6206 files touched by this commit		 Jimmy Olgeni (olgeni) search for other commits by this committer 
databases/pgschema: Update to 1.12.5
1.12.4_1
23 Aug 2026 20:46:21
commit hash: 55e5b6fe9a9839310493f5f022648f70387c96b0commit hash: 55e5b6fe9a9839310493f5f022648f70387c96b0commit hash: 55e5b6fe9a9839310493f5f022648f70387c96b0commit hash: 55e5b6fe9a9839310493f5f022648f70387c96b0 files touched by this commit		 Jimmy Olgeni (olgeni) search for other commits by this committer 
databases/pgschema: Update to 1.12.4

- Follow upstream rename to the pgplex organization
1.5.1_10
19 Aug 2026 17:39:04
commit hash: 4867821cd65241b6e8c0faa3ed76d67514594442commit hash: 4867821cd65241b6e8c0faa3ed76d67514594442commit hash: 4867821cd65241b6e8c0faa3ed76d67514594442commit hash: 4867821cd65241b6e8c0faa3ed76d67514594442 files touched by this commit		 Dag-Erling Smørgrav (des) search for other commits by this committer 
various: Bump go ports for go-1.25.14 / 1.26.7
1.5.1_9
14 Aug 2026 00:38:09
commit hash: 6d39dcf04e96d7cdbad58d1b7f27d25d8e3b75b8commit hash: 6d39dcf04e96d7cdbad58d1b7f27d25d8e3b75b8commit hash: 6d39dcf04e96d7cdbad58d1b7f27d25d8e3b75b8commit hash: 6d39dcf04e96d7cdbad58d1b7f27d25d8e3b75b8 files touched by this commit		 Dag-Erling Smørgrav (des) search for other commits by this committer 
various: Bump go ports for go-1.25.13 / 1.26.6
1.5.1_8
10 Jul 2026 07:54:15
commit hash: 4ea354713284ca756537346a9ebc6df56184ed31commit hash: 4ea354713284ca756537346a9ebc6df56184ed31commit hash: 4ea354713284ca756537346a9ebc6df56184ed31commit hash: 4ea354713284ca756537346a9ebc6df56184ed31 files touched by this commit		 Dag-Erling Smørgrav (des) search for other commits by this committer 
various: Bump go ports for go-1.25.12 / 1.26.5
1.5.1_7
03 Jun 2026 17:54:22
commit hash: dd8dc2a59ddc46a12ace1cc4f7a953de512853bdcommit hash: dd8dc2a59ddc46a12ace1cc4f7a953de512853bdcommit hash: dd8dc2a59ddc46a12ace1cc4f7a953de512853bdcommit hash: dd8dc2a59ddc46a12ace1cc4f7a953de512853bd files touched by this commit		 Dag-Erling Smørgrav (des) search for other commits by this committer 
various: Bump go ports for go-1.25.11 / go-1.26.4
1.5.1_6
09 May 2026 17:25:51
commit hash: 4e243a83f8d8d5cd511bba2b689931886b3a57cecommit hash: 4e243a83f8d8d5cd511bba2b689931886b3a57cecommit hash: 4e243a83f8d8d5cd511bba2b689931886b3a57cecommit hash: 4e243a83f8d8d5cd511bba2b689931886b3a57ce files touched by this commit		 Adam Weinberger (adamw) search for other commits by this committer 
various: Bump ports for Go 1.25.10
1.5.1_5
10 Apr 2026 15:57:27
commit hash: 7507e72a845b5c83e1ad035bd54b1c35482fb86acommit hash: 7507e72a845b5c83e1ad035bd54b1c35482fb86acommit hash: 7507e72a845b5c83e1ad035bd54b1c35482fb86acommit hash: 7507e72a845b5c83e1ad035bd54b1c35482fb86a files touched by this commit		 Dag-Erling Smørgrav (des) search for other commits by this committer 
various: Bump go ports for go-1.25.9 / 1.26.2
1.5.1_4
06 Mar 2026 03:33:23
commit hash: a8d318da7c159b84ddff6a525e2e39800ab3f795commit hash: a8d318da7c159b84ddff6a525e2e39800ab3f795commit hash: a8d318da7c159b84ddff6a525e2e39800ab3f795commit hash: a8d318da7c159b84ddff6a525e2e39800ab3f795 files touched by this commit		 Adam Weinberger (adamw) search for other commits by this committer 
various: Bump ports for Go 1.25.8
1.5.1_3
11 Feb 2026 19:21:45
commit hash: 97685c188649d678a8a0e5fde3e8ecb842bf9422commit hash: 97685c188649d678a8a0e5fde3e8ecb842bf9422commit hash: 97685c188649d678a8a0e5fde3e8ecb842bf9422commit hash: 97685c188649d678a8a0e5fde3e8ecb842bf9422 files touched by this commit		 Adam Weinberger (adamw) search for other commits by this committer 
various: Bump ports for Go default 1.24->1.25
1.5.1_2
05 Feb 2026 16:48:00
commit hash: 529df949a5b00103a138f1defddc73ef64750f2fcommit hash: 529df949a5b00103a138f1defddc73ef64750f2fcommit hash: 529df949a5b00103a138f1defddc73ef64750f2fcommit hash: 529df949a5b00103a138f1defddc73ef64750f2f files touched by this commit		 Adam Weinberger (adamw) search for other commits by this committer 
various: Bump Go ports for 1.24.13
1.5.1_1
16 Jan 2026 17:49:03
commit hash: 013f2d30b04bfe9e8d278b7bfad96a64b72c36dacommit hash: 013f2d30b04bfe9e8d278b7bfad96a64b72c36dacommit hash: 013f2d30b04bfe9e8d278b7bfad96a64b72c36dacommit hash: 013f2d30b04bfe9e8d278b7bfad96a64b72c36da files touched by this commit		 Adam Weinberger (adamw) search for other commits by this committer 
various: Bump Go ports for 1.24.12
1.5.1
19 Dec 2025 09:46:09
commit hash: 14e3b7fa9a55d16d11288dade89d38a54baae3e3commit hash: 14e3b7fa9a55d16d11288dade89d38a54baae3e3commit hash: 14e3b7fa9a55d16d11288dade89d38a54baae3e3commit hash: 14e3b7fa9a55d16d11288dade89d38a54baae3e3 files touched by this commit		 Jimmy Olgeni (olgeni) search for other commits by this committer 
databases/pgschema: Update to 1.5.1
1.5.0
05 Dec 2025 16:04:03
commit hash: 1c3a4f03513f8e8cd55f61c2ce954001189cf4fecommit hash: 1c3a4f03513f8e8cd55f61c2ce954001189cf4fecommit hash: 1c3a4f03513f8e8cd55f61c2ce954001189cf4fecommit hash: 1c3a4f03513f8e8cd55f61c2ce954001189cf4fe files touched by this commit		 Jimmy Olgeni (olgeni) search for other commits by this committer 
databases/pgschema: Update to 1.5.0
1.1.0_4
03 Dec 2025 18:24:45
commit hash: b24429e3ede02a855f8e7ecb3564af0287306483commit hash: b24429e3ede02a855f8e7ecb3564af0287306483commit hash: b24429e3ede02a855f8e7ecb3564af0287306483commit hash: b24429e3ede02a855f8e7ecb3564af0287306483 files touched by this commit		 Adam Weinberger (adamw) search for other commits by this committer 
various: Bump Go ports for 1.24.11
1.1.0_3
06 Nov 2025 17:03:19
commit hash: 0dfced16fb0f78e71c42a767df8b6f394a185d6ccommit hash: 0dfced16fb0f78e71c42a767df8b6f394a185d6ccommit hash: 0dfced16fb0f78e71c42a767df8b6f394a185d6ccommit hash: 0dfced16fb0f78e71c42a767df8b6f394a185d6c files touched by this commit		 Adam Weinberger (adamw) search for other commits by this committer 
various: Bump Go ports for 1.24.10
1.1.0_2
14 Oct 2025 15:13:55
commit hash: 90f976619bf883b36d921c6ab89ffc5ff156b391commit hash: 90f976619bf883b36d921c6ab89ffc5ff156b391commit hash: 90f976619bf883b36d921c6ab89ffc5ff156b391commit hash: 90f976619bf883b36d921c6ab89ffc5ff156b391 files touched by this commit		 Adam Weinberger (adamw) search for other commits by this committer 
various: Bump go ports for go-1.24.9
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: 22
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
mailpitSep 19
angieSep 18
angie-module-njsSep 18
varnish7Sep 18
vinyl09Sep 18
389-ds-baseSep 17
emacs*Sep 16
emacs-devel*Sep 16
immich*Sep 16
mkvtoolnixSep 16
nginxSep 16
nginx-develSep 16
traefikSep 16
unboundSep 16
ankiSep 14

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

* - modified, not new

All vulnerabilities

Last processed:
2026-09-19 12:33:00 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 35192
Broken 83
Deprecated 337
Ignore 201
Forbidden 0
Restricted 1
No CDROM 1
Vulnerable 45
Expired 15
Set to expire 265
Interactive 0
new 24 hours 15
new 48 hours20
new 7 days48
new fortnight111
new month206
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2026 Dan Langille. All rights reserved.