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
pgespresso Optional extension to Barman backup and recovery manager
1.2_3 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 1.2Version of this port present on the latest quarterly branch.
Maintainer: matthew@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2014-12-02 15:37:41
Last Update: 2019-07-26 21:46:57
SVN Revision: 507372
License: PostgreSQL
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (8 items)
  1. lib/postgresql/pgespresso.so
  2. share/postgresql/extension/pgespresso--1.0--1.1.sql
  3. share/postgresql/extension/pgespresso--1.1--1.2.sql
  4. share/postgresql/extension/pgespresso--1.2.sql
  5. share/postgresql/extension/pgespresso.control
  6. /usr/local/share/licenses/pgespresso-1.2_3/catalog.mk
  7. /usr/local/share/licenses/pgespresso-1.2_3/LICENSE
  8. /usr/local/share/licenses/pgespresso-1.2_3/PostgreSQL
Collapse this list.
Dependency lines:
  • pgespresso>0:databases/pgespresso
To install the port: cd /usr/ports/databases/pgespresso/ && make install clean
To add the package: pkg install pgespresso
PKGNAME: pgespresso
Flavors: there is no flavor information for this port.
distinfo:

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake : devel/gmake
  2. postgres : databases/postgresql95-server
Runtime dependencies:
  1. postgres : databases/postgresql95-server
There are no ports dependent upon this port

Configuration Options

USES:

Master Sites:
  1. https://codeload.github.com/2ndquadrant-it/pgespresso/tar.gz/1.2?dummy=/

Number of commits found: 11

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
26 Jul 2019 20:46:57
Original commit files touched by this commit  1.2_3
Revision:507372
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330
26 Mar 2019 14:15:59
Original commit files touched by this commit  1.2_2
Revision:496898
matthew search for other commits by this committer
State that pgespresso is only needed with postgresql versions 9.2, 9.3,
9.4 or 9.5.  For 9.6 and above, there is an equivalent built-in
mechanism.
12 Dec 2018 01:35:36
Original commit files touched by this commit  1.2_1
Revision:487272
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590
10 Sep 2018 13:14:52
Original commit files touched by this commit  1.2
Revision:479406
mat search for other commits by this committer
Add DOCS options to ports that should have one.

Also various fixes related to said option.

PR:		230864
Submitted by:	mat
exp-runs by:	antoine
24 Jun 2018 00:54:27
Original commit files touched by this commit  1.2
Revision:473169
linimon search for other commits by this committer
Workaround the following problem on aarch64 by setting LLD_UNSAFE=yes:

  cc: error: invalid linker name in argument '-fuse-ld=bfd'

Neither emaste nor I can figure out exactly where the offending stanza is
coming in.  It will take someone with more knowledge of gmake debug flags,
and possibly the src build infrastructure, to figure it out.

While here, pet portlint.

Approved by:	portmgr (tier-2 blanket)
22 Jul 2016 07:05:12
Original commit files touched by this commit  1.2
Revision:418911
matthew search for other commits by this committer
Update to version 1.2

ChangeLog: https://github.com/2ndquadrant-it/pgespresso/blob/master/ChangeLog
24 May 2016 09:44:05
Original commit files touched by this commit  1.1_1
Revision:415775
matthew search for other commits by this committer
Fix plist

Reported by:	pkg-fallout
23 May 2016 10:30:10
Original commit files touched by this commit  1.1
Revision:415712
matthew search for other commits by this committer
Update to version 1.1
  - Remove patch as this has been incorporated upstream.  Release 1.1
    is functionally identical to the previous 1.0 port + patch.

ChangeLog: https://github.com/2ndquadrant-it/pgespresso/blob/master/ChangeLog
18 Jan 2016 10:01:00
Original commit files touched by this commit  1.0_1
Revision:406555
matthew search for other commits by this committer
Apply patch from upstream GitHub to provide compile- and run-time
compatibility with postgresql95

Obtained
from:	https://github.com/2ndquadrant-it/pgespresso/commit/7bedbfb894aedff8c08de85ede430a15a8888a0a
06 May 2015 15:16:54
Original commit files touched by this commit  1.0
Revision:385521
mat search for other commits by this committer
Update ports in the [bcd]* categories to not use GH_COMMIT.

With minor cleanups to make things simpler.

With hat:	portmgr
Sponsored by:	Absolight
02 Dec 2014 15:37:30
Original commit files touched by this commit  1.0
Revision:373767
matthew search for other commits by this committer
New port:

pgespresso is an extension to postgresql that adds functions and views
to be used by Barman, the disaster recovery tool

WWW: https://github.com/2ndquadrant-it/pgespresso

Number of commits found: 11

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
jenkinsJan 29
jenkins-ltsJan 29
pkgJan 29
pkg-develJan 29
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

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

* - modified, not new

All vulnerabilities

Last updated:
2020-01-29 15:30:09


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38571
Broken 678
Deprecated 497
Ignore 948
Forbidden 3
Restricted 150
No CDROM 72
Vulnerable 28
Expired 7
Set to expire 469
Interactive 0
new 24 hours 2
new 48 hours146
new 7 days170
new fortnight218
new month317

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