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

Hardware failure

The website is running on the old server. The new server stopped working at about 0200 UTC on 2020-08-22. The database was restored from 2020-08-21 00:59:15+00 UTC. We think we have covered all commits. Nothing should be missing. Any changes you made to your accounts after the restore date will be lost. Sorry about that.
Port details
postgresql92-client PostgreSQL database (client)
9.2.24_1 databases Deleted on this many watch lists=6 search for ports that depend on this port An older version of this port was marked as vulnerable. Find issues related to this port Report an issue related to this port View this port on Repology. 9.2.24_1Version of this port present on the latest quarterly branch. NOTE: Slave port - quarterly revision is most likely wrong.
Deprecated DEPRECATED: PostgreSQL 9.2 support has reached End-of-line. Please upgrade to a later version.
Expired This port expired on: 2017-04-05
Maintainer: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2012-05-15 22:15:58
Last Update: 2018-02-10 22:14:39
SVN Revision: 461440

People watching this port, also watch: python27, bash, postfix

License: PostgreSQL
Description:
SVNWeb : Homepage

There is no configure plist information for this port.

Dependency lines:
  • postgresql92-client>0:databases/postgresql92-client
  • libecpg.so:databases/postgresql92-client
No installation instructions: this port has been deleted.
The package name of this deleted port was:
PKGNAME: postgresql92-client
Flavors: there is no flavor information for this port.
distinfo:
Packages: (move your mouse over the cells for more information)
postgresql92-client
ABIlatestquarterly
FreeBSD:11:aarch64--
FreeBSD:11:amd64--
FreeBSD:11:armv69.2.17-
FreeBSD:11:i386--
FreeBSD:11:mips9.2.17_2-
FreeBSD:11:mips649.2.17_2-
FreeBSD:12:aarch64--
FreeBSD:12:amd64--
FreeBSD:12:armv6--
FreeBSD:12:armv7--
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips64--
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
 

Master port: databases/postgresql92-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.24<5.25 : lang/perl5.24
Runtime dependencies:
  1. perl5>=5.24<5.25 : lang/perl5.24
Library dependencies:
  1. libreadline.so.7 : devel/readline
  2. 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 11 deleted ports
    1. databases/jasperserver*
    2. databases/pgpool-II*
    3. databases/pgpool-II-30*
    4. databases/postgresql92-contrib*
    5. databases/postgresql92-pgtcl*
    6. databases/postgresql92-server*
    7. devel/preps-gui*
    8. dns/powerdns-devel*
    9. mail/dspam-devel*
    10. net/ser*
    11. net-im/iserverd*
    12. 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:
Expand this list (1 items)
    Collapse this list.
  1. https://ftp.postgresql.org/pub/source/v9.2.24/
  2. Collapse this list.
Port Moves
  • port moved to databases/postgresql93-client on 2018-02-10
    REASON: Has expired: PostgreSQL 9.2 support has reached End-of-life. Please upgrade to a later version

Number of commits found: 19

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/postgresql92-server
DateByDescription
10 Feb 2018 22:14:39
Original commit files touched by this commit  9.2.24_1
Revision:461440
rene search for other commits by this committer
Removed expired postgresql92 ports.
08 Feb 2018 17:38:36
Original commit files touched by this commit  9.2.24_1
Revision:461251
girgen search for other commits by this committer
Update to latest versions of PostgreSQL

2018-02-08 Security Update Release
==================================

The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 10.2, 9.6.7, 9.5.11, 9.4.16, 9.3.21.
This release fixes two security issues. This release also fixes issues with
VACUUM, GIN indexes, and hash indexes that could lead to data corruption, as
well as fixes for using parallel queries and logical replication.

All users using the affected versions of PostgreSQL should update as soon as
possible. Please see the notes on "Updating" below for any post-update steps
that may be required.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
05 Sep 2017 09:27:11
Original commit files touched by this commit  9.2.23
Revision:449278
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 9.6.5, 9.5.9,
9.4.14, 9.3.19, and 9.2.23.

This release includes fixes that prevent a crash in pg_restore when
using parallel mode. It also patches over a few other bugs reported
since the last releases in August.

Additionally, in 9.4.14 only, there is a fix to an issue with walsenders
preventing primary-server shutdown unless immediate shutdown mode is used.

Users should plan to update at the next convenient downtime.

Bug Fixes and Improvements
(Only the first 15 lines of the commit message are shown above View all of this commit message)
17 Jul 2017 11:15:50
Original commit files touched by this commit  9.2.21_2
Revision:446065
amdmi3 search for other commits by this committer
- Include pg_regress to all postgresql*-client ports, to allow running
regression tests for postgresql extensions

PR:		217874
Approved by:	maintainer timeout (pgsql, 4 months)
28 Jun 2017 14:51:22
Original commit files touched by this commit  9.2.21_1
Revision:444580
sunpoet search for other commits by this committer
Bump PORTREVISION for devel/readline shlib change

PR:		219947
13 Jan 2016 10:36:22
Original commit files touched by this commit  9.2.14_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.2.14
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.2.11
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.2.10_1
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.2.10
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
25 Aug 2014 17:53:27
Original commit files touched by this commit  9.2.9
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.2.8_1
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.2.7
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.2.5
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.2.4
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.2.4
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.2.4
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.2.4
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)
15 May 2012 22:14:55
Original commit files touched by this commit  9.2.b1

girgen search for other commits by this committer
The PostgreSQL Global Development Group announces the beta release of
PostgreSQL 9.2, which will include major increases in performance and
both vertical and horizontal scalability.  The PostgreSQL Project asks
all users to download and begin testing 9.2 Beta as soon as possible.

Major performance and scalability advances in this version include:

* Index-only scans, allowing users to avoid inefficient scans of base
  tables
* Enhanced read-only workload scaling to 64 cores and over 300,000
  queries per second
* Improvements to data write speeds, including group commit
* Reductions in CPU power consumption
* Cascading replication, supporting geographically distributed standby
  databases
(Only the first 15 lines of the commit message are shown above View all of this commit message)

Number of commits found: 19

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
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
motionOct 28
freetype2Oct 22
chromiumOct 21
mysql56-serverOct 21
mysql57-serverOct 21
mysql80-serverOct 21
mariadb103-clientOct 18
mariadb103-serverOct 18
mariadb104-clientOct 18
mariadb104-serverOct 18
mariadb105-clientOct 18
mariadb105-serverOct 18
drupal7Oct 17
py-matrix-synapseOct 17
powerdns-recursorOct 14

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

* - modified, not new

All vulnerabilities

Last updated:
2020-10-28 10:26:17


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 41271
Broken 57
Deprecated 270
Ignore 295
Forbidden 4
Restricted 146
No CDROM 73
Vulnerable 19
Expired 9
Set to expire 241
Interactive 0
new 24 hours 7
new 48 hours11
new 7 days37
new fortnight113
new month195

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