notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Why was the website so slow for so long?

The cause of the slowdown was a change to the ZFS dataset. In conjunction with the database server, very little caching was being done. This combination resulted in increased disk I/O as the system churned through the database. Details in the blog post which outlines the various things which changed. Many graphs.

Port details
postgresql90-client PostgreSQL database (client)
9.0.23 databases Deleted on this many watch lists=13 search for ports that depend on this port This port version is marked as vulnerable. Find issues related to this port Report an issue related to this port 9.0.23Version of this port present on the latest quarterly branch. NOTE: Slave port - quarterly revision is most likely wrong.
Deprecated DEPRECATED: "EOL was reached in September 2015"
Expired This port expired on: 2016-04-13
Maintainer: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2010-09-20 13:48:16
Last Update: 2016-07-02 00:25:18
SVN Revision: 417905
License: not specified in port
Description:
SVNWeb : Homepage

There is no configure plist information for this port.

Dependency lines:
  • postgresql90-client>0:databases/postgresql90-client
No installation instructions: this port has been deleted.
The package name of this deleted port was:
PKGNAME: postgresql90-client
Flavors: there is no flavor information for this port.
distinfo:
There is no distinfo for this port.

Master port: databases/postgresql90-server

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake : devel/gmake
  2. msgfmt : devel/gettext-tools
  3. perl5>=5.20<5.21 : lang/perl5.20
Runtime dependencies:
  1. perl5>=5.20<5.21 : lang/perl5.20
Library dependencies:
  1. libintl.so : devel/gettext-runtime
NOTE: dependencies for deleted ports are notoriously suspect
This port is required by:
for Libraries

    Deleted ports which required this port:

    Expand this list of 18 deleted ports
    1. databases/aolserver-nspostgres*
    2. databases/libgda3-postgresql*
    3. databases/ludia*
    4. databases/php52-pdo_pgsql*
    5. databases/php52-pgsql*
    6. databases/postgis*
    7. databases/postgresql-libpq++*
    8. databases/postgresql90-contrib*
    9. databases/postgresql90-docs*
    10. databases/postgresql90-pgtcl*
    11. databases/postgresql90-server*
    12. databases/qt-pgsql-plugin*
    13. dns/bind97-sdb*
    14. net/asterisk10*
    15. net/asterisk14*
    16. sysutils/rsyslog5-pgsql*
    17. sysutils/rsyslog6-devel-pgsql*
    18. sysutils/rsyslog6-pgsql*
    19. Collapse this list of deleted ports.
* - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...

Configuration Options

USES:

Master Sites:
  1. ftp://ftp.postgresql.org/pub/source/v9.0.23/
  2. http://distcache.FreeBSD.org/ports-distfiles/postgresql/
  3. http://ftp.postgresql.org/pub/source/v9.0.23/
  4. https://ftp.postgresql.org/pub/source/v9.0.23/
Port Moves
  • port deleted on 2016-06-21
    REASON: Postgresql 9.0 EoL Upstream as of September 2015

Number of commits found: 27

Commit History - (may be incomplete: see SVNWeb link above for full details)
This is a slave port. You may also want to view the commits to the master port: databases/postgresql90-server
DateByDescription
01 Jul 2016 23:25:18
Original commit files touched by this commit  9.0.23
Revision:417905 This port version is marked as vulnerable.
rene search for other commits by this committer
Prune empty postgresql90-* directories.
01 Jul 2016 17:45:51
Original commit files touched by this commit  9.0.23
Revision:417899 This port version is marked as vulnerable.
matthew search for other commits by this committer
Delete the now expired postgresql90 ports.  Upstream support for
postgresql-9.0.x was declared EoL in September 2015.

Summary:
Remove 9.0 from the list of postgresql versions available in ports

Disconnect postgresql90 ports from the build

Remove postgresql90-pgtcl port

Remove postgresql90-client port

Move the master postgreslXY-plperl makefile to postgresql95-plperl/Makefile.

Adjust include lines in other postgresqlXY-plperl ports
(Only the first 15 lines of the commit message are shown above View all of this commit message)
16 May 2016 19:08:39
Original commit files touched by this commit  9.0.23
Revision:415357 This port version is marked as vulnerable.
rene search for other commits by this committer
Re-add databases/postgresql90-client, databases/pg_rman still needs it

Submitted by:	cperciva via IRC
16 May 2016 17:39:45
Original commit files touched by this commit  9.0.23
Revision:415344  Sanity Test Failure This port version is marked as vulnerable.
rene search for other commits by this committer
Remove expired ports:
2016-04-13 databases/postgresql90-contrib: "EOL was reached in September 2015"
2016-04-13 databases/postgresql90-pltcl: "EOL was reached in September 2015"
2016-04-13 databases/postgresql90-client: "EOL was reached in September 2015"
2016-04-13 databases/postgresql90-docs: "EOL was reached in September 2015"
2016-04-13 databases/postgresql90-server: "EOL was reached in September 2015"
13 Jan 2016 10:36:22
Original commit files touched by this commit  9.0.23_1
Revision:406034 This port version is marked as vulnerable.
girgen search for other commits by this committer
Some binaries where moved from contrib to base in 9.5, like pgbench and
pg_upgrade. Other where added in 9.5, but the port failed to install them.
Make sure they are properly installed by the correct port (-client or -server)
[1]

Remove unused and hence confusing OSSP_UUID parameters from Makefile [2]

Add options to allow user to be set for the backup script in periodic.
Add this option only to 9.5 for now. It will be updated to other servers at
next regular patch release. [3]

The path to perl in hard coded into pgxs/src/Makefile.global which is
then installed. Hence, we must depend on perl when that file is installed.

Noticed by:	Paul Guyot [1]
PR:		192387 [2]
PR:		172110 [3]
PR:		206046 [4]
08 Oct 2015 21:25:01
Original commit files touched by this commit  9.0.23
Revision:398895 This port version is marked as vulnerable.
girgen search for other commits by this committer
Update PostgreSQL port to latest version.

Two security issues have been fixed in this release which affect users
of specific PostgreSQL features:

CVE-2015-5289: json or jsonb input values constructed from arbitrary
user input can crash the PostgreSQL server and cause a denial of
service.

CVE-2015-5288: The crypt( function included with the optional pgCrypto
extension could be exploited to read a few additional bytes of memory.
No working exploit for this issue has been developed.

This update will also disable SSL renegotiation by default;
previously, it was enabled by default.   SSL renegotiation will be
removed entirely in PostgreSQL versions 9.5 and later.

URL:		http://www.postgresql.org/about/news/1615/
Security:	CVE-2015-5288 CVE-2015-5289
22 May 2015 23:22:20
Original commit files touched by this commit  9.0.20
Revision:387089 This port version is marked as vulnerable.
girgen search for other commits by this committer
Update PostgreSQL ports to latest version.

Data Corruption Fix

For users of PostgreSQL versions 9.3 or 9.4, this release fixes a problem where
the database will fail to protect against "multixact wraparound", resulting in
data corruption or loss. Users with a high transaction rate (1 million or more
per hour) in a database with many foreign keys are especially vulnerable. We
strongly urge all users of 9.4 and 9.3 to update their installations in the
next few days.

Users of versions 9.2 and earlier are not affected by this issue.

Security:	fc38cd83-00b3-11e5-8ebd-0026551a22dc
07 Feb 2015 17:05:08
Original commit files touched by this commit  9.0.19
Revision:378604 This port version is marked as vulnerable.
girgen search for other commits by this committer
Revert the change from readline to libedit, and instead make libedit optional.
PR:	ports/197362
05 Feb 2015 22:54:35
Original commit files touched by this commit  9.0.19
Revision:378500 This port version is marked as vulnerable.
girgen search for other commits by this committer
Update PostgreSQL-9.x to latests versions.

This update fixes multiple security issues reported in PostgreSQL over the past
few months. All of these issues require prior authentication, and some require
additional conditions, and as such are not considered generally urgent.
However, users should examine the list of security holes patched below in case
they are particularly vulnerable.

Security:	CVE-2015-0241,CVE-2015-0242,CVE-2015-0243,
		CVE-2015-0244,CVE-2014-8161
12 Nov 2014 09:53:42
Original commit files touched by this commit  9.0.18
Revision:372487 This port version is marked as vulnerable.
girgen search for other commits by this committer
Revert r247147.
We need -pthread in LDFLAGS for threaded extensions like plv8js to work.

PR:		175783
Submitted by:	Li-Wen Hsu <lwhsu@FreeBSD.org>
25 Aug 2014 17:53:27
Original commit files touched by this commit  9.0.18
Revision:366114 This port version is marked as vulnerable.
crees search for other commits by this committer
Convert pgsql ports to use USES+=pgsql

Reviewed by:	bapt
30 Jun 2014 23:07:29
Original commit files touched by this commit  9.0.17
Revision:359941 This port version is marked as vulnerable.
bapt search for other commits by this committer
Fixes build with readline from ports
26 Feb 2014 17:24:36
Original commit files touched by this commit  9.0.16
Revision:346217 This port version is marked as vulnerable.
antoine search for other commits by this committer
Stage support

Reviewed by:	postgresql@
Tested by:	miwi and me
15 Oct 2013 17:17:06
Original commit files touched by this commit  9.0.14
Revision:330414 This port version is marked as vulnerable.
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)
10 Oct 2013 00:09:35
Original commit files touched by this commit  9.0.13
Revision:329946 This port version is marked as vulnerable.
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.0.13
Revision:329729 This port version is marked as vulnerable.
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.0.13
Revision:329725 This port version is marked as vulnerable.
jgh search for other commits by this committer
- Fix pkg name collision

Reviewed by: crees@
With hat: pgsql@
20 Sep 2013 16:13:49
Original commit files touched by this commit  9.0.13
Revision:327717 This port version is marked as vulnerable.
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
04 Jun 2012 11:00:52
Original commit files touched by this commit  9.0.8
 This port version is marked as vulnerable.
girgen search for other commits by this committer
The PostgreSQL Global Development Group today released security updates for all
active branches of the PostgreSQL database system, including versions 9.1.4,
9.0.8, 8.4.12 and 8.3.19.

Users of the crypt(text, text) function with DES encryption in the optional
pg_crypto module should upgrade their installations immediately, if you have'nt
already updated since the port was patched on May 30.  All other database
administrators are urged to upgrade your version of PostgreSQL at the
next scheduled downtime.

URL:      http://www.postgresql.org/about/news/1398/

Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-2143
          Fix incorrect password transformation in contrib/pgcrypto’s DES
crypt() function
          This was fixed in a patch release for the FreeBSD ports on May 30.

Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-2655
          Ignore SECURITY DEFINER and SET attributes for a procedural
language’s call handle
28 Feb 2012 21:37:40
Original commit files touched by this commit  9.0.7_1
 This port version is marked as vulnerable.
girgen search for other commits by this committer
Fix pkg-plist
25 Jan 2012 21:12:33
Original commit files touched by this commit  9.0.6
 This port version is marked as vulnerable.
crees search for other commits by this committer
- To preserve my sanity, slave 82 and 83 to 84, and 90 to 91, resulting in
  three fewer Makefiles to maintain

- Switch patch master site

- Various cleanups
18 Oct 2011 09:03:33
Original commit files touched by this commit  9.0.5
 This port version is marked as vulnerable.
girgen search for other commits by this committer
The PostgreSQL Global Development Group today released minor version updates
for all active branches of the PostgreSQL object-relational database system,
including versions 9.1.1, 9.0.5, 8.4.9, 8.3.16 and 8.2.22.

All users are strongly urged to update their installations at the next
scheduled downtime.

URL:    http://www.postgresql.org/about/news.1355

Cleanup ports. Better handling of the knob PG_USER.
Also add uuid to 9.0 and 9.1 contrib ports.
02 May 2011 21:37:31
Original commit files touched by this commit  9.0.4_1
 This port version is marked as vulnerable.
girgen search for other commits by this committer
Fix a problem with creating the postgresql user when using a package.
31 Dec 2010 09:57:21
Original commit files touched by this commit  9.0.2
 This port version is marked as vulnerable.
mm search for other commits by this committer
- Update to 9.0.2
- Unify ICU handling

PR:             ports/153245
Approved by:    maintainer (timeout)
26 Oct 2010 12:34:27
Original commit files touched by this commit  9.0.1_1
 This port version is marked as vulnerable.
girgen search for other commits by this committer
Make postgresql90-client depend on libxml. Technically it does not depend on
libxml,
only postgresql90-server does, but since we don't want two different pg_config
setups,
one for client and one for server, I'm bringing the libxml dependency on board
until
I can find out a better way to solve this.
07 Oct 2010 06:58:10
Original commit files touched by this commit  9.0.0
 This port version is marked as vulnerable.
girgen search for other commits by this committer
Update all PostgreSQL ports to latest versions.

Also, try to break the previous 1:1 relation between FreeBSD system and
PostgreSQL versions installed. Use different PREFIX:es to install
different versions on the same system.

PR: ports/132402, ports/145002, ports/146657
20 Sep 2010 13:46:47
Original commit files touched by this commit  9.0.0
 This port version is marked as vulnerable.
girgen search for other commits by this committer
PostgreSQL 9.0 is here!  The PostgreSQL Global Development Group
announces the availability of our most eagerly awaited release.
PostgreSQL 9.0 includes built-in, binary replication, and over a dozen
other major features which will appeal to everyone from web developers
to database hackers.

9.0 includes more major features than any release before it, including:
* Hot standby
* Streaming replication
* In-place upgrades
* 64-bit Windows builds
* Easy mass permissions management
* Anonymous blocks and named parameter calls for stored procedures
* New windowing functions and ordered aggregates
(Only the first 15 lines of the commit message are shown above View all of this commit message)

Number of commits found: 27

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?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
samba410Jan 27
webkit2-gtk3Jan 26
py-pillowJan 24
giteaJan 18
drm-current-kmodJan 15
drm-devel-kmodJan 15
drm-fbsd11.2-kmodJan 15
drm-fbsd12.0-kmodJan 15
mariadb101-serverJan 15
mariadb102-serverJan 15
mariadb103-serverJan 15
mariadb104-serverJan 15
mariadb55-serverJan 15
mysql56-serverJan 15
mysql57-serverJan 15

8 vulnerabilities affecting 131 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-01-27 01:40:43


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38667
Broken 687
Deprecated 694
Ignore 960
Forbidden 3
Restricted 152
No CDROM 72
Vulnerable 26
Expired 2
Set to expire 666
Interactive 0
new 24 hours 2
new 48 hours11
new 7 days34
new fortnight77
new month205

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