BSD Portsdatabases/postgresql18-server 18.6 MidnightBSD
PostgreSQL is the most advanced open-source database available anywhere
- System
- MidnightBSD
- Repository
- mports
- Maintainer
- [email protected]
- Port added
- Last update
- Commit
1bcf1eb8ac- License
- pgsql
- Categories
- databases
Description
PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. It is the most advanced open-source database available anywhere. Commercial Support is also available.
The original Postgres code was the effort of many graduate students, undergraduate students, and staff programmers working under the direction of Professor Michael Stonebraker at the University of California, Berkeley. In 1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query language to SQL and created a new database system which came to known as Postgres95. Many others contributed to the porting, testing, debugging and enhancement of the Postgres95 code. As the code improved, and 1995 faded into memory, PostgreSQL was born.
PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The development team coordinator is Marc G. Fournier ([email protected]). Support is available from the PostgreSQL developer/user community through the support mailing list ([email protected]).
PostgreSQL is free and the complete source is available.
In the other systems
| System | Port | Version |
|---|---|---|
| MidnightBSD | databases/postgresql18-server | 18.6 |
| FreeBSD | databases/postgresql18-server | 18.6 |
| NetBSD | databases/postgresql18-server | 18.6 |
| HardenedBSD | databases/postgresql18-server | 18.6 |
| GhostBSD | databases/postgresql18-server | 18.6 |
Install
Binary package:
mport install postgresql${PORTVERSION:R}${COMPONENT}From mports:
cd /usr/mports/databases/postgresql18-server && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= postgresql${PORTVERSION:R}${COMPONENT}>0:databases/postgresql18-serverDependencies
No port depends on this one.
Configuration
No options to configure.
- USES
- tar:bzip2 cpe
- Service scripts
- none
- Conflicts with
- postgresql1[^${PORTVERSION:R:C/.*([0-9]$)/\\1/}]*
Files
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| postgresql/postgresql-18.6.tar.bz2 | 2.2632314e+07 | 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f |
Master sites 1
- PGSQL/source/v18.6
Commit history 7
| Date | Commit | Credits | Log message |
|---|---|---|---|
1bcf1eb8ac |
Lucas Holt | databases/postgresql18-server: update to 18.6 (#1693) ## Summary
- Update PostgreSQL 18 to 18.6 and regenerate distinfo.
- Restore server plist entries omitted by checked-in truncated output.
## Validation
- Server: makesum, patch, build, fake, and package passed.
- Client and contrib packages built successfully.
- check-license and git diff --check passed.
- portlint -C still reports existing Makefile/work-directory findings.
Built on MidnightBSD 4.2 with the installed PostgreSQL 14 client
bypassed for version and conflict checks. Stable/4.0 was not exercised.
## Summary by Sourcery
Update the PostgreSQL 18 server port to release 18.6 with refreshed
packaging metadata.
Bug Fixes:
- Restore the complete PostgreSQL 18 server package file list, including
entries omitted from the checked-in plist.
Enhancements:
… |
|
21cea7c76c |
Lucas Holt | databases/postgresql18-server: fix doubled staging path when stripping client binaries (#1507) Fixes the Magus \`make fake\` failure for postgresql15-client
(https://www.midnightbsd.org/magus/ports/2261566) and
postgresql16-client.
\`do-install\` already receives \`\${FAKE_DESTDIR}\` prepended to
\`\${PREFIX}\`, so the CLIENT_ONLY strip line's explicit
\`\${FAKE_DESTDIR}\${PREFIX}\` doubled the staging path and \`strip\`
failed with "No such file or directory". Dropping the extra
\`\${FAKE_DESTDIR}\` matches the other strip lines in the same target.
Not build-tested locally (this session runs on Linux); please confirm
via a Magus rerun of the client ports.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
## Summary by Sourcery
Bug Fixes:
- Fix client-only PostgreSQL staging installs by preventing the strip
step from duplicating the fake destination path.
… |
|
a05b377b53 |
Lucas Holt | *: bump PORTREVISION for the textproc/libxml2 2.15 shared library change (#848) `textproc/libxml2` 2.15 changed SONAME from `libxml2.so.2` to
`libxml2.so.16` **and** removed ELF symbol versioning entirely — the new
library defines no `LIBXML2_*` versions at all. Consumers built against
the old library were never rebuilt, so they still record a dependency on
`libxml2.so.2` plus version requirements nothing can satisfy, and fail
at load time:
```
ld-elf.so.1: /usr/local/lib/libxml2.so.2: version LIBXML2_2.4.30 required by
/usr/local/lib/libevdocument3.so.4 not defined
```
### Scope
`Tools/scripts/bump_revision.pl -f -l textproc/libxml2` — **436
Makefiles**: 323 revisions incremented, 113 gained a `PORTREVISION`
line. The diff touches nothing but `PORTREVISION` lines (verified: `git
diff -U0` shows no other changed line), and spot-checked ports still
… |
|
0808ab8bdf |
Lucas Holt | Fix Magus build and fake failures Fix PostgreSQL client staging, uv's Cargo install path, and Boost Python with NumPy 2.
AI-Assisted-by: Codex (GPT-5) <[email protected]>
Signed-off-by: Lucas Holt <[email protected]> |
|
49c0f7c33c |
Lucas Holt | databases/postgresql18-server: fix fake installation (#777) ## Summary
- pass the mports fake-install arguments to PostgreSQL install targets
- use fake-adjusted PREFIX and DOCSDIR paths exactly once
- fix the shared staging logic used by PostgreSQL 15 and 16 clients
## Magus failures
- postgresql15-client, ID 2249593, amd64: fake failed when strip
received a duplicated fake-root path
- postgresql16-client, ID 2249601, amd64: same failure
- analyzer classification: Partially supported; it identified the
duplicated staging path but missed the omitted FAKE_MAKEARGS
## Validation
- postgresql15-client 15.18: build, fake, and package passed
- postgresql16-client 16.14: build, fake, and package passed
- check-license passed for both clients
- client test targets exited successfully; no substantive client tests
were defined
… |
The latest 5 of 7 in the history this site was built from.