FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

I am looking for an LTO tape library. Do you have one to spare?
Port details
postgresql94-server The most advanced open-source database available anywhere
9.4.0 databases on this many watch lists=1 search for ports that depend on this port Find issues related to this port Report an issue related to this port
Maintainer: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 18 May 2014 14:45:02
License: not specified in port
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 (scrappy@PostgreSQL.ORG).
Support is available from the PostgreSQL developer/user community through the
support mailing list (questions@PostgreSQL.ORG).

PostgreSQL is free and the complete source is available.

WWW: http://www.postgresql.org/
SVNWeb : Homepage : Distfiles Availability : PortsMon
Slave ports
  1. databases/postgresql94-client
  2. databases/postgresql94-contrib
  3. databases/postgresql94-docs
  4. databases/postgresql94-plperl
  5. databases/postgresql94-plpython
  6. databases/postgresql94-pltcl

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. /usr/local/lib/libcrypto.so.8 : security/openssl
  2. gmake : devel/gmake
  3. msgfmt : devel/gettext-tools
Runtime dependencies:
  1. /usr/local/lib/libcrypto.so.8 : security/openssl
Library dependencies:
  1. libxml2.so : textproc/libxml2
  2. libpq.so.5 : databases/postgresql94-client
  3. libintl.so : devel/gettext-runtime

This port is required by:

for Build for Run * - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...

To install the port: cd /usr/ports/databases/postgresql94-server/ && make install clean
To add the package: pkg install databases/postgresql94-server


Configuration Options
===> The following configuration options are available for postgresql94-server-9.4.0:
     DEBUG=off: Builds with debugging symbols
     DTRACE=off: Build with DTrace probes (server only)
     GSSAPI=off: Build with GSSAPI support
     ICU=off: Use ICU for unicode collation (server)
     INTDATE=on: Builds with 64-bit date/time type (server)
     LDAP=off: Build with LDAP authentication support (server only)
     NLS=on: Use internationalized messages
     OPTIMIZED_CFLAGS=off: Builds with compiler optimizations (-O3)
     PAM=off: Build with PAM Support
     SSL=on: Build with OpenSSL support
     TZDATA=on: Use internal timezone database (server)
     XML=on: Build with XML data type (server)
====> Build with kerberos provider support: you can only select none or one of them
     MIT_KRB5=off: Build with MIT kerberos support
     HEIMDAL_KRB5=off: Builds with Heimdal kerberos
===> Use 'make config' to modify these settings

Master Sites:
  1. ftp://ftp.ee.postgresql.org/mirrors/postgresql/source/v9.4.0/
  2. ftp://ftp.gr.postgresql.org/pub/databases/postgresql/source/v9.4.0/
  3. ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/source/v9.4.0/
  4. ftp://ftp.lv.postgresql.org/pub/postgresql/source/v9.4.0/
  5. ftp://ftp.postgresql.org/pub/source/v9.4.0/
  6. ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/source/v9.4.0/
  7. ftp://ftp2.cz.postgresql.org/pub/postgresql/source/v9.4.0/
  8. ftp://ftp2.it.postgresql.org/mirrors/postgres/source/v9.4.0/
  9. ftp://ftp2.nl.postgresql.org/mirror/postgresql/source/v9.4.0/
  10. ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/source/v9.4.0/
  11. ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/source/v9.4.0/
  12. ftp://ftp3.tw.postgresql.org/pub/postgresql/source/v9.4.0/
  13. ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v9.4.0/
  14. ftp://ftp6.pl.postgresql.org/pub/postgresql/source/v9.4.0/
  15. ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org/source/v9.4.0/
  16. ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/source/v9.4.0/
  17. http://distcache.FreeBSD.org/ports-distfiles/postgresql/
  18. http://ftp2.jp.postgresql.org/pub/postgresql/source/v9.4.0/
  19. http://ring.nict.go.jp/archives/misc/db/postgresql/source/v9.4.0/

Number of commits found: 9

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
18 Dec 2014 15:42:18
Original commit files touched by this commit  9.4.0
Revision:374908
girgen search for other commits by this committer
Release PostgreSQL 9.4

Major enhancements in PostgreSQL 9.4 include:

Add jsonb, a more capable and efficient data type for storing JSON data

Add new SQL command ALTER SYSTEM for changing postgresql.conf configuration
file entries

Reduce lock strength for some ALTER TABLE commands

Allow materialized views to be refreshed without blocking concurrent reads

Add support for logical decoding of WAL data, to allow database changes to be
streamed out in a customizable format

Allow background worker processes to be dynamically registered, started and
terminated The above items are explained in more detail in the sections below.

URL:	http://www.postgresql.org/docs/9.4/static/release-9-4.html
19 Nov 2014 16:09:15
Original commit files touched by this commit  9.4.r1
Revision:372796
girgen search for other commits by this committer
Update PostgreSQL 9.4 to release candidate 1.
09 Oct 2014 15:20:53
Original commit files touched by this commit  9.4.b3
Revision:370540
girgen search for other commits by this committer
Update to PostgreSQL 9.4 beta3
25 Aug 2014 16:44:08
Original commit files touched by this commit  9.4.b1_1
Revision:366094
antoine search for other commits by this committer
Remove some duplicate lines from plist (or duplicate plist)

Reported by:	pkg developer mode
02 Aug 2014 07:01:54
Original commit files touched by this commit  9.4.b1_1
Revision:363792
mva search for other commits by this committer
- Unbreak builds after the lang/python27 update (r363790)

Exp-run:	192242, 192244
09 Jun 2014 21:57:43
Original commit files touched by this commit  9.4.b1_1
Revision:357209
girgen search for other commits by this committer
Prepare for upcoming ICU-5.3 upgrade.
31 May 2014 16:37:58
Original commit files touched by this commit  9.4.b1_1
Revision:355995
ak search for other commits by this committer
- Fix various distinfo errors
- Remove unused USE_* knobs
- Convert USE_TWISTED_RUN to USES
- Remove empty lines after .include <bsd.port.mk>

Approved by:	portmgr (antoine)
20 May 2014 21:58:23
Original commit files touched by this commit  9.4.b1_1
Revision:354693
girgen search for other commits by this committer
fix broken plist
18 May 2014 14:44:53
Original commit files touched by this commit  9.4.b1
Revision:354425
girgen search for other commits by this committer
The PostgreSQL Global Development Group announced that the first beta
release of PostgreSQL 9.4, the latest version of the world's leading
open source database, is available today.  This beta contains previews
of all of the features which will be available in version 9.4, and is
ready for testing by the worldwide PostgreSQL community.  Please
download, test, and report what you find.

Major Features
--------------

The new major features available for testing in this beta include:

* JSONB: 9.4 includes the new JSONB "binary JSON" type. This new
  storage format for document data is higher-performance, and comes with
  indexing, functions and operators for manipulating JSON data.
* Replication: The new Data Change Streaming API allows decoding and
  transformation of the replication stream.  This lays the foundation
  for new replication tools that support high-speed and more flexible
  replication and scale-out solutions.
* Materialized Views with "Refresh Concurrently", which permit
  fast-response background summary reports for complex data.
* ALTER SYSTEM SET, which enables modifications to postgresql.conf
  from the SQL command line and from remote clients, easing
  administration tasks.

Number of commits found: 9

Login
User Login
Create account

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

This site
What is FreshPorts?
About the authors
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
muttDec 23
muttDec 23
ntpDec 20
ntp-develDec 20
gitDec 19
otrsDec 16
mod_dav_svnDec 15
subversionDec 15
subversion16Dec 15
subversion17Dec 15
nvidia-driverDec 14
nvidia-driver-173Dec 14
nvidia-driver-304Dec 14
asterisk11Dec 11
bind99Dec 11

10 vulnerabilities affecting 28 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 24439
Broken 148
Deprecated 75
Ignore 399
Forbidden 2
Restricted 207
No CDROM 93
Vulnerable 20
Expired 0
Set to expire 70
Interactive 0
new 24 hours 6
new 48 hours7
new 7 days21
new fortnight43
new month99

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2014 Dan Langille. All rights reserved.