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
postgresql93-server 9.3.5 databases on this many watch lists=7 search for ports that depend on this port
The most advanced open-source database available anywhere
Maintained by: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 11 May 2013 23:46:44
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 : Main Web Site : Distfiles Availability : PortsMon
Slave ports
  1. databases/postgresql93-client
  2. databases/postgresql93-contrib
  3. databases/postgresql93-docs
  4. databases/postgresql93-plperl
  5. databases/postgresql93-plpython
  6. databases/postgresql93-pltcl

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

Required To Build:
  1. security/openssl
  2. devel/gmake
Required To Run:
  1. security/openssl
Required Libraries:
  1. textproc/libxml2
  2. devel/gettext
  3. databases/postgresql93-client

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/postgresql93-server/ && make install clean
To add the package: pkg install databases/postgresql93-server


Configuration Options
===> The following configuration options are available for postgresql93-server-9.3.5:
     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)
     KRB5=off: Build with kerberos provider support
     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 have to select exactly 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.3.5/
  2. ftp://ftp.gr.postgresql.org/pub/databases/postgresql/source/v9.3.5/
  3. ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/source/v9.3.5/
  4. ftp://ftp.lv.postgresql.org/pub/postgresql/source/v9.3.5/
  5. ftp://ftp.postgresql.org/pub/source/v9.3.5/
  6. ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/source/v9.3.5/
  7. ftp://ftp2.cz.postgresql.org/pub/postgresql/source/v9.3.5/
  8. ftp://ftp2.it.postgresql.org/mirrors/postgres/source/v9.3.5/
  9. ftp://ftp2.nl.postgresql.org/mirror/postgresql/source/v9.3.5/
  10. ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/source/v9.3.5/
  11. ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/source/v9.3.5/
  12. ftp://ftp3.tw.postgresql.org/pub/postgresql/source/v9.3.5/
  13. ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v9.3.5/
  14. ftp://ftp6.pl.postgresql.org/pub/postgresql/source/v9.3.5/
  15. ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org/source/v9.3.5/
  16. ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/source/v9.3.5/
  17. http://distcache.FreeBSD.org/ports-distfiles/postgresql/
  18. http://ftp2.jp.postgresql.org/pub/postgresql/source/v9.3.5/
  19. http://ring.nict.go.jp/archives/misc/db/postgresql/source/v9.3.5/
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2012-05-30
    Affects: users of databases/postgresql*-server
    Author: jgh@FreeBSD.org
    Reason: 
      Affected users are those who use the crypt(text, text) function with
      DES encryption in the optional pg_crypto module. Passwords affected
      are those that contain characters that cannot be represented with
      7-bit ASCII. If a password contains a character that has the most
      significant bit set (0x80), and DES encryption is used, that character
      and all characters after it will be ignored.
    
    

Number of commits found: 27

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
02 Aug 2014 07:01:54
Original commit files touched by this commit  9.3.5
Revision:363792
mva search for other commits by this committer
- Unbreak builds after the lang/python27 update (r363790)

Exp-run:	192242, 192244
30 Jul 2014 18:21:47
Original commit files touched by this commit  9.3.5
Revision:363500
crees search for other commits by this committer
Update to the latest snapshots.

uuid-ossp patch has been outdated with irrelevant changes (for us),
so massage back in.

In head of postgresql, this is handled properly, so eventually the ossp patches
can go.
12 Jun 2014 12:46:52
Original commit files touched by this commit  9.3.4
Revision:357591
girgen search for other commits by this committer
In preparation for upcoming ICU-5.3 upgrade, I failed to update distfile on
slave ports
21 Mar 2014 08:15:26
Original commit files touched by this commit  9.3.4
Revision:348732
girgen search for other commits by this committer
Fix mistake with ossp-uuid: don't use --with-ossp-uuid, since it will need
the ossp library present, and then we never use it.
20 Mar 2014 13:43:16
Original commit files touched by this commit  9.3.4
Revision:348685
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all supported
version of the database system, including versions 9.3.4, 9.2.8, 9.1.13,
9.0.17, and 8.4.21. This minor release fixes a data corruption issue with
replication and crash recovery in version 9.3, as well as several other minor
issues in all versions.  All users of version 9.3 are urged to update their
installations at the next possible downtime.  Users of older versions should
update at their convenience.

The data corruption issue in PostgreSQL 9.3 affects binary replication
standbys, servers being recovered from point-in-time-recovery backup, and
standalone servers which recover from a system crash. The bug causes
unrecoverable index corruption during recovery due to incorrect replay of row
locking operations.  This can then cause query results to be inconsistent
depending on whether or not an index is used, and eventually lead to primary
key violations and similar issues.  For this reason, users are encouraged to
(Only the first 15 lines of the commit message are shown above View all of this commit message)
26 Feb 2014 17:24:36
Original commit files touched by this commit  9.3.3
Revision:346217
antoine search for other commits by this committer
Stage support

Reviewed by:	postgresql@
Tested by:	miwi and me
20 Feb 2014 18:11:38
Original commit files touched by this commit  9.3.3
Revision:345257
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an important
update to all supported versions of the PostgreSQL database system,
which includes minor versions 9.3.3, 9.2.7, 9.1.12, 9.0.16, and
8.4.20. This update contains fixes for multiple security issues, as
well as several fixes for replication and data integrity issues.  All
users are urged to update their installations at the earliest
opportunity, especially those using binary replication or running a
high-security application.

This update fixes CVE-2014-0060, in which PostgreSQL did not properly
enforce the WITH ADMIN OPTION permission for ROLE management. Before
this fix, any member of a ROLE was able to grant others access to the
same ROLE regardless if the member was given the WITH ADMIN OPTION
permission. It also fixes multiple privilege escalation issues,
including: CVE-2014-0061, CVE-2014-0062, CVE-2014-0063, CVE-2014-0064,
CVE-2014-0065, and CVE-2014-0066. More information on these issues can
be found on our security page and the security issue detail wiki page.

Security:	CVE-2014-0060,CVE-2014-0061,CVE-2014-0062,CVE-2014-0063
		CVE-2014-0064,CVE-2014-0065,CVE-2014-0066,CVE-2014-0067
10 Feb 2014 23:46:46
Original commit files touched by this commit  9.3.2
Revision:343714
girgen search for other commits by this committer
fix messed up file sizes for icu patch
10 Feb 2014 16:32:41
Original commit files touched by this commit  9.3.2
Revision:343650
girgen search for other commits by this committer
Chase ICU update
05 Dec 2013 15:59:53
Original commit files touched by this commit  9.3.2
Revision:335673
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released a critical update
to all supported versions of the PostgreSQL database system, which
includes minor versions 9.3.2, 9.2.6, 9.1.11, 9.0.15, and 8.4.19. This
update fixes three serious data-loss bugs affecting replication and
database maintenance.  All users are urged to update their
installations at the earliest opportunity.

URL:	http://www.postgresql.org/about/news/1492/
28 Oct 2013 18:52:22
Original commit files touched by this commit  9.3.1
Revision:331888
sunpoet search for other commits by this committer
- Fix PLIST for python3

Submitted by:	sunpoet (myself)
Approved by:	crees (pgsql)
15 Oct 2013 17:17:06
Original commit files touched by this commit  9.3.1
Revision:330414
sunpoet search for other commits by this committer
- Remove DISTV: only used in PKGNAMESUFFIX and complained by portlint
- Convert to new LIB_DEPENDS format for postgresql*-contrib

Submitted by:	sunpoet (myself)
Reviewed by:	crees (pgsql)
Approved by:	jgh (pgsql)
12 Oct 2013 00:59:50
Original commit files touched by this commit  9.3.1
Revision:330109
girgen search for other commits by this committer
Update PostgreSQL ports to 9.3.1, 9.2.5, 9.1.10, 9.0.14, and 8.4.18.

Note that users of the hstore extension on version 9.3 must take an additional,
post upgrade step of running "ALTER EXTENSION hstore UPDATE" in each database
after update.

URL:	http://www.postgresql.org/about/news/1487/
10 Oct 2013 00:09:35
Original commit files touched by this commit  9.3.0_1
Revision:329946
jgh search for other commits by this committer
- Fix pkg name collision

Reviewed by: pgsql@
With hat: pgsql@
07 Oct 2013 20:03:38
Original commit files touched by this commit  9.3.0_1
Revision:329729
jgh search for other commits by this committer
- revert r329725

Reported by: qat@
With hat: pgsql@
07 Oct 2013 19:04:04
Original commit files touched by this commit  9.3.0_1
Revision:329725
jgh search for other commits by this committer
- Fix pkg name collision

Reviewed by: crees@
With hat: pgsql@
29 Sep 2013 20:19:01
Original commit files touched by this commit  9.3.0_1
Revision:328729
crees search for other commits by this committer
Fix plist

PR:		ports/182489
Submitted by:	antoine
20 Sep 2013 16:13:49
Original commit files touched by this commit  9.3.0_1
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
18 Sep 2013 08:56:51
Original commit files touched by this commit  9.3.0_1
Revision:327537
girgen search for other commits by this committer
Install libpgcommon.a, required by extensions.

PR:	ports/182190
09 Sep 2013 15:45:44
Original commit files touched by this commit  9.3.0
Revision:326817
girgen search for other commits by this committer
Update to postgreSQL 9.3.0

Major enhancements in PostgreSQL 9.3 include:
- Add materialized views
- Make simple views auto-updatable
- Add many features for the JSON data type, including operators and functions to
extract elements from JSON values
- Implement SQL-standard LATERAL option for FROM-clause subqueries and function
calls
- Allow foreign data wrappers to support writes (inserts/updates/deletes) on
foreign tables
- Add a Postgres foreign data wrapper to allow access to other Postgres servers
- Add support for event triggers
- Add optional ability to checksum data pages and report corruption
- Prevent non-key-field row updates from blocking foreign key checks
- Greatly reduce System V shared memory requirements

URL:	http://www.postgresql.org/docs/9.3/static/release-9-3.html
28 Jun 2013 10:50:52
Original commit files touched by this commit  9.3.b2
Revision:321954
girgen search for other commits by this committer
Update PostgreSQL 93 to beta 2.

URL:	http://www.postgresql.org/about/news/1471/
15 May 2013 23:21:28
Original commit files touched by this commit  9.3.b1_1
Revision:318267
girgen search for other commits by this committer
Add missing pb_basebackup
12 May 2013 22:28:38
Original commit files touched by this commit  9.3.b1
Revision:317984
girgen search for other commits by this committer
pkgconfig belongs under libdata
12 May 2013 21:11:26
Original commit files touched by this commit  9.3.b1
Revision:317979
girgen search for other commits by this committer
Properly bump PORTREVISION on postgresql-client-9.3.beta1
12 May 2013 21:09:39
Original commit files touched by this commit  9.3.b1
Revision:317978
girgen search for other commits by this committer
Update postgresql93-client to properly depend on pkgconfig
Reported by: Ports-QAT
12 May 2013 00:00:56
Original commit files touched by this commit  9.3.b1
Revision:317925
girgen search for other commits by this committer
Add postgresql 9.3 beta1
11 May 2013 23:46:30
Original commit files touched by this commit  9.2.4
Revision:317924
girgen search for other commits by this committer
Prepare for postgresql 9.3 beta 1 by svn cp postgresql92-* postgresql93-*

Number of commits found: 27

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
chromiumAug 26
fileAug 21
py-djangoAug 21
py-django-develAug 21
py-django14Aug 21
py-django15Aug 21
php53Aug 18
phpmyadminAug 17
chromiumAug 13
serfAug 11
subversionAug 11
subversion17Aug 11
nginxAug 09
nginx-develAug 09
mingw32-opensslAug 06

6 vulnerabilities affecting 9 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 24510
Broken 217
Deprecated 730
Ignore 561
Forbidden 36
Restricted 261
No CDROM 101
Vulnerable 23
Expired 0
Set to expire 720
Interactive 0
new 24 hours 5
new 48 hours8
new 7 days55
new fortnight93
new month254

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