BSD Ports

databases/postgresql19-client 19.r1 FreeBSD

PostgreSQL database (client)

System
FreeBSD
Repository
FreeBSD ports
Maintainer
[email protected]
Port added
Last update
Commit
60c44ec8a9
License
PostgreSQL
Categories
databases
Package size
3969.7 KiB, 19290.6 KiB installed

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.

Install

Binary package:

pkg install postgresql19-client

From the ports tree:

cd /usr/ports/databases/postgresql19-client/ && make install clean

To depend on this port in another port's Makefile:

RUN_DEPENDS=	postgresql19-client>0:databases/postgresql19-client

Packages

The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.

Repositoryaarch64amd64armv6armv7i386
FreeBSD:14:latest19.b419.b4--19.r1
FreeBSD:14:quarterly19.b419.b4n/a-19.b4
FreeBSD:15:latest19.b419.r1n/a--
FreeBSD:15:quarterly19.b419.b4n/an/an/a
FreeBSD:16:latest19.b419.r1n/an/an/a
FreeBSD:16:quarterlyn/an/an/an/an/a

Dependencies

As this port's Makefile names them.

Build 4

The full lists below include those, and their dependencies in turn.

Build dependencies 29
Run dependencies 5

Configuration

Options name: databases_postgresql

OptionDefaultDescription
DOCSoffBuild and/or install documentation
LIBEDIToffUse non-GPL libedit instead of readline
USES
pkgconfig
Service scripts
none

Message after installing

The PostgreSQL port has a collection of "side orders":

postgresql-docs
  For all of the html documentation

p5-Pg
  A perl5 API for client access to PostgreSQL databases.

postgresql-tcltk
  If you want tcl/tk client support.

postgresql-jdbc
  For Java JDBC support.

postgresql-odbc
  For client access from unix applications using ODBC as access
  method. Not needed to access unix PostgreSQL servers from Win32
  using ODBC. See below.

ruby-postgres, py-psycopg
  For client access to PostgreSQL databases using the ruby & python
  languages.

postgresql-plperl, postgresql-pltcl & postgresql-plruby
  For using perl5, tcl & ruby as procedural languages.

postgresql-contrib
  Lots of contributed utilities, postgresql functions and
  datatypes. There you find pg_standby, pgcrypto and many other cool
  things.

etc...

Files

No file lists for this port.

Commit history 1

DateCommitCreditsLog message
60c44ec8a9 Palle Girgensohn databases/postgresql??-*: Update to latest versions
Update to 18.6, 17.11, 16.15, 15.19 and 14.24. This release fixes 28 security vulnerabilities and over 110 bugs reported over the last several months. Welcome postgresql19 to the ports tree with 19-beta3. Note: PostgreSQL 18.5 was skipped due to a regression; the fix version is 18.6. PostgreSQL 14 will stop receiving fixes on 2026-11-12. Changes: https://www.postgresql.org/about/news/postgresql-186-1711-1615-1519-1424-and-19-beta-3-released-3365/ Security: 05d311bc-9991-11f1-bc50-6cc21735f730