FreshPorts -- databases/postgresql-libpgeasy: Easy-to-use C interface to PostgreSQL

Port details

postgresql-libpgeasy Easy-to-use C interface to PostgreSQL

3.0.4_3 databases =4 3.0.4_3Version of this port present on the latest quarterly branch.

Maintainer: pgsql@FreeBSD.org

Port Added: 2005-07-21 22:52:31

Last Update: 2022-09-07 21:58:51

Commit Hash: fb16dfe

People watching this port, also watch:: postgresql-relay, postgresql-libpqxx, dspam, ap24-mod_fcgid, fcgi-devkit

License: not specified in port

WWW:

https://www.postgresql.org/docs/7.2/static/pgeasy.html

Description:

Pgeasy is a PostgreSQL API that is a cleaner interface to the libpq library, more like an SQL 4GL interface. There are examples in share/examples/postgresql/libpqeasy and docs in share/doc/postgresql/libpqeasy

¦ ¦ ¦ ¦

Manual pages:

FreshPorts has no man page information for this port.

pkg-plist: as obtained via: make generate-plist

Expand this list (15 items)

Collapse this list.

@ldconfig
include/libpgeasy.h
lib/libpgeasy.a
lib/libpgeasy.so
lib/libpgeasy.so.3
lib/libpgeasy.so.3.0.0
share/examples/postgresql/libpgeasy/Makefile
share/examples/postgresql/libpgeasy/pginsert.c
share/examples/postgresql/libpgeasy/pgmultiresult.c
share/examples/postgresql/libpgeasy/pgnulltest.c
share/examples/postgresql/libpgeasy/pgwordcount.c
share/doc/postgresql/libpgeasy/libpgeasy.html
@owner
@group
@mode

Collapse this list.

Dependency lines:

postgresql-libpgeasy>0:databases/postgresql-libpgeasy

To install the port:

cd /usr/ports/databases/postgresql-libpgeasy/ && make install clean

To add the package, run one of these commands:

pkg install databases/postgresql-libpgeasy
pkg install postgresql-libpgeasy

NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.

PKGNAME: postgresql-libpgeasy

Flavors: there is no flavor information for this port.

distinfo:

SHA256 (postgresql/libpgeasy-3.0.4.tar.gz) = d14020a796173deed048422db976ad9c692a2c4a3253c8d834b0ebb70e66067a SIZE (postgresql/libpgeasy-3.0.4.tar.gz) = 175985

Packages (timestamps in pop-ups are UTC):

postgresql-libpgeasy
ABI	aarch64	amd64	armv6	armv7	i386	powerpc	powerpc64	powerpc64le
FreeBSD:13:latest	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3	-	3.0.4_3	-
FreeBSD:13:quarterly	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3
FreeBSD:14:latest	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3	-	3.0.4_3
FreeBSD:14:quarterly	3.0.4_3	3.0.4_3	-	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3	3.0.4_3
FreeBSD:15:latest	3.0.4_3	3.0.4_3	n/a	3.0.4_3	n/a	3.0.4_3	3.0.4_3	3.0.4_3

Dependencies

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

Build dependencies:

gmake>=4.3 : devel/gmake

Library dependencies:

libpq.so.5 : databases/postgresql13-client

There are no ports dependent upon this port

Configuration Options:

===> The following configuration options are available for postgresql-libpgeasy-3.0.4_3: DOCS=on: Build and/or install documentation EXAMPLES=on: Build and/or install examples ===> Use 'make config' to modify these settings

Options name:

databases_postgresql-libpgeasy

USES:

gmake libtool pgsql

FreshPorts was unable to extract/find any pkg message

Master Sites:

Expand this list (1 items)

Collapse this list.

https://ftp.postgresql.org/pub/projects/gborg/pgeasy/stable/

Collapse this list.

Notes from UPDATING

These upgrade notes are taken from /usr/ports/UPDATING

2024-07-23

Affects: users of databases/postgresql* and other software using PostgreSQL to run

Author: kbowling@FreeBSD.org

Reason: 
  The default version of PostgreSQL has been switched from 15 to 16.
  The upgrade procedure can use up twice the space the databases
  currently needs. If you have a big amount of stored data take a
  closer look at the manpage of pg_upgrade for avoidance and/or
  speedup of the upgrade.

  The upgrade instructions consider a basic usage and do not match
  complex scenarios like replication, sharding, or similar.

  Upgrade instructions:

  First stop your PostgreSQL, create PostgreSQL-binaries and backup your data.
  If you have another Version of PostgreSQL installed, for example 15, your
  files are named according to this.

  # service postgresql stop
  # pkg create postgresql15-server postgresql15-contrib
  # mkdir /tmp/pg-upgrade
  # tar xf postgresql15-server-15.7.pkg -C /tmp/pg-upgrade
  # tar xf postgresql15-contrib-15.7.pkg -C /tmp/pg-upgrade
  # pkg delete -f databases/postgresql15-server databases/postgresql15-contrib databases/postgresql15-client

  Now update PostgreSQL:

    pkg user:
    # pkg install databases/postgresql16-server databases/postgresql16-contrib
    # pkg upgrade

    Portmaster users:
    # portmaster databases/postgresql16-server databases/postgresql16-contrib
    # portmaster -a

    Portupgrade users:
    # portinstall databases/postgresql16-server databases/postgresql16-contrib
    # portupgrade -a

  After installing the new PostgreSQL version you need to convert
  all your databases to new version:

  # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data16 -U postgres"
  # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data15/ -B /usr/local/bin/ -D /var/db/postgres/data16/ -U postgres "

  Now the migration is finished. You can start PostgreSQL again with:

  # service postgresql start

  ATTENTION:
  1) If you use non-default initdb options, you have to adjust the initdb-command accordingly

Expand this list (2 items)

2023-09-08

Affects: users of databases/postgresql* and other software using PostgreSQL to run

Author: kbowling@FreeBSD.org

Reason: 
  The default version of PostgreSQL has been switched from 13 to 15.
  The upgrade procedure can use up twice the space the databases
  currently needs. If you have a big amount of stored data take a
  closer look at the manpage of pg_upgrade for avoidance and/or
  speedup of the upgrade.

  The upgrade instructions consider a basic usage and do not match
  complex scenarios like replication, sharding, or similar.

  Upgrade instructions:

  First stop your PostgreSQL, create PostgreSQL-binaries and backup your data.
  If you have another Version of PostgreSQL installed, for example 13, your
  files are named according to this.

  # service postgresql stop
  # pkg create postgresql13-server postgresql13-contrib
  # mkdir /tmp/pg-upgrade
  # tar xf postgresql13-server-13.12.pkg -C /tmp/pg-upgrade
  # tar xf postgresql13-contrib-13.12.pkg -C /tmp/pg-upgrade
  # pkg delete -f databases/postgresql13-server databases/postgresql13-contrib databases/postgresql13-client

  Now update PostgreSQL:

    pkg user:
    # pkg install databases/postgresql15-server databases/postgresql15-contrib
    # pkg upgrade

    Portmaster users:
    # portmaster databases/postgresql15-server databases/postgresql15-contrib
    # portmaster -a

    Portupgrade users:
    # portinstall databases/postgresql15-server databases/postgresql15-contrib
    # portupgrade -a

  After installing the new PostgreSQL version you need to convert
  all your databases to new version:

  # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data15 -U postgres"
  # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data13/ -B /usr/local/bin/ -D /var/db/postgres/data15/ -U postgres "

  Now the migration is finished. You can start PostgreSQL again with:

  # service postgresql start

  ATTENTION:
  1) The default user changed from "pgsql" to "postgres" in 11. The migration steps above now assume
     the "postgres" database user and FreeBSD user.
  2) See the updating entry 20190829 if you are updating from a release prior to 11.
  3) If you use non-default initdb options, you have to adjust the initdb-command accordingly

2021-10-24

Affects: users of databases/postgresql* and other software using PostgreSQL to run

Author: kbowling@FreeBSD.org

Reason: 
  The default version of PostgreSQL has been switched from 12 to 13.
  The upgrade procedure can use up twice the space the databases
  currently needs. If you have a big amount of stored data take a
  closer look at the manpage of pg_upgrade for avoidance and/or
  speedup of the upgrade.

  The upgrade instructions consider a basic usage and do not match
  complex scenarios like replication, sharding, or similar.

  Upgrade instructions:

  First stop your PostgreSQL, create PostgreSQL-binaries and backup your data.
  If you have another Version of PostgreSQL installed, for example 12.8, your
  files are named according to this.

  # service postgresql stop
  # pkg create postgresql12-server postgresql12-contrib
  # mkdir /tmp/pg-upgrade
  # tar xf postgresql12-server-12.8.pkg -C /tmp/pg-upgrade
  # tar xf postgresql12-contrib-12.8.pkg -C /tmp/pg-upgrade
  # pkg delete -f databases/postgresql12-server databases/postgresql12-contrib databases/postgresql12-client

  Now update PostgreSQL:

    pkg user:
    # pkg install databases/postgresql13-server databases/postgresql13-contrib
    # pkg upgrade

    Portmaster users:
    # portmaster databases/postgresql13-server databases/postgresql13-contrib
    # portmaster -a

    Portupgrade users:
    # portinstall databases/postgresql13-server databases/postgresql13-contrib
    # portupgrade -a

  After installing the new PostgreSQL version you need to convert
  all your databases to new version:

  # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data13 -U postgres"
  # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data12/ -B /usr/local/bin/ -D /var/db/postgres/data13/ -U postgres "

  Now the migration is finished. You can start PostgreSQL again with:

  # service postgresql start

  ATTENTION:
  1) The default user changed from "pgsql" to "postgres" in 11. The migration steps above now assume
     the "postgres" database user and FreeBSD user.
  2) See the updating entry 20190829 if you are updating from a release prior to 11.
  3) If you use non-default initdb options, you have to adjust the initdb-command accordingly

Collapse this list.

Number of commits found: 25

Commit	Credits	Log message
Commit History - (may be incomplete: for full details, see links to repositories near top of page)
07 Sep 2022 21:58:51	Stefan Eßer (se)	Remove WWW entries moved into port Makefiles Commit b7f05445c00f has added WWW entries to port Makefiles based on WWW: lines in pkg-descr files. This commit removes the WWW: lines of moved-over URLs from these pkg-descr files. Approved by: portmgr (tcberner)
3.0.4_3 07 Sep 2022 21:10:59	Stefan Eßer (se)	Add WWW entries to port Makefiles It has been common practice to have one or more URLs at the end of the ports' pkg-descr files, one per line and prefixed with "WWW:". These URLs should point at a project website or other relevant resources. Access to these URLs required processing of the pkg-descr files, and they have often become stale over time. If more than one such URL was present in a pkg-descr file, only the first one was tarnsfered into the port INDEX, but for many ports only the last line did contain the port specific URL to further information. There have been several proposals to make a project URL available as a macro in the ports' Makefiles, over time. (Only the first 15 lines of the commit message are shown above )
3.0.4_3 20 Jul 2022 14:21:07	Tobias C. Berner (tcberner)	databases: remove 'Created by' lines A big Thank You to the original contributors of these ports: * "Choe, Cheng-Dae" whitekid * "Mahdi Mokhtari <mokhi64@gmail.com>" * "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de> * <hvo.pm@xs4all.nl> * <jsmith@resonatingmedia.com> * <ports@c0decafe.net> * Aaron Dalton <aaron@FreeBSD.org> * Adam Weinberger <adamw@FreeBSD.org> * Ade Lovett <ade@FreeBSD.org> * Akinori MUSHA aka knu <knu@idaemons.org> * Alan Snelson <Alan@Wave2.org> (Only the first 15 lines of the commit message are shown above )
3.0.4_3 06 Apr 2021 14:31:07	Mathieu Arnold (mat)	Remove # $FreeBSD$ from Makefiles.
3.0.4_3 26 Jul 2019 20:46:57	gerald	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
3.0.4_2 12 Dec 2018 01:35:36	gerald	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
3.0.4_1 27 May 2016 18:27:15	crees	Fix URL Submitted by: Tim Jackson <tim.jackson@whoishostingthismail.com>
3.0.4_1 14 May 2015 10:15:09	mat	MASTER_SITES cleanup. - Replace ${MASTER_SITE_FOO} with FOO. - Merge MASTER_SITE_SUBDIR into MASTER_SITES when possible. (This means 99.9% of the time.) - Remove occurrences of MASTER_SITE_LOCAL when no subdirectory was present and no hint of what it should be was present. - Fix some logic. - And generally, make things more simple and easy to understand. While there, add magic values to the FESTIVAL, GENTOO, GIMP, GNUPG, QT and SAMBA macros. Also, replace some EXTRACT_SUFX occurences with USES=tar:*. Checked by: make fetch-urlall-list With hat: portmgr Sponsored by: Absolight
3.0.4_1 20 Oct 2014 10:41:13	bapt	Cleanup plist
3.0.4_1 25 Aug 2014 17:53:27	crees	Convert pgsql ports to use USES+=pgsql Reviewed by: bapt
3.0.4_1 05 May 2014 13:48:25	bapt	Convert to USES=pgsql While here: databases/pg_reorg - stagify databases/iplike - convert to USES=libtool - strip binarie databases/ip4r - strip binaries databases/postgresql-libpgeasy - convert to USES=libtool - strip binaries - stagify databases/postgresql-libpqxx - convert to USES=libtool - strip binaries databases/postgresql-libpqxx3 - convert to USES=libtool - strip binaries
3.0.4_1 20 Sep 2013 16:13:49	bapt	Add NO_STAGE all over the place in preparation for the staging support (cat: databases)
3.0.4_1 07 Jul 2013 00:15:47	jgh	- convert from USE_GMAKE to USES=gmake - trim historical headers With hat: pgsql@
3.0.4_1 04 Mar 2012 17:19:59	crees	Over to new team, pgsql@FreeBSD.org
3.0.4_1 08 Feb 2012 14:01:32	eadler	Remove whitespace after b.p.m to help reduce false postives when searching for other junk after b.p.m Trivial non-functional change so maintainer not contacted Submitted by: Alex Kozlov
3.0.4_1 19 Jan 2012 03:35:49	tabthorpe	- Reset ports due to maintainer timeouts and lack of response to emails With hat: portmgr
3.0.4_1 20 Mar 2011 12:54:45	miwi	- Get Rid MD5 support
3.0.4_1 04 Dec 2010 07:34:27	ade	Sync to new bsd.autotools.mk
3.0.4_1 02 Aug 2009 19:36:34	mezz	-Repocopy devel/libtool15 -> libtool22 and libltdl15 -> libltdl22. -Update libtool and libltdl to 2.2.6a. -Remove devel/libtool15 and devel/libltdl15. -Fix ports build with libtool22/libltdl22. -Bump ports that depend on libltdl22 due to shared library version change. -Explain what to do update in the UPDATING. It has been tested with GNOME2, XFCE4, KDE3, KDE4 and other many wm/desktop and applications in the runtime. With help: marcus and kwm Pointyhat-exp: a few times by pav Tested by: pgollucci, "Romain TartiÃ¨re" <romain@blogreen.org>, and a few MarcusCom CVS users. Also, I might have missed a few. Repocopy by: marcus Approved by: portmgr
3.0.4_1 06 Jun 2008 13:17:10	edwin	Bump portrevision due to upgrade of devel/gettext. The affected ports are the ones with gettext as a run-dependency according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT in Makefile (29 of them). PR: ports/124340 Submitted by: edwin@ Approved by: portmgr (pav)
3.0.4 19 Apr 2008 17:56:05	miwi	- Remove unneeded dependency from gtk12/gtk20 [1] - Remove USE_XLIB/USE_X_PREFIX/USE_XPM in favor of USE_XORG - Remove X11BASE support in favor of LOCALBASE or PREFIX - Use USE_LDCONFIG instead of INSTALLS_SHLIB - Remove unneeded USE_GCC 3.4+ Thanks to all Helpers: Dmitry Marakasov, Chess Griffin, beech@, dinoex, rafan, gahr, ehaupt, nox, itetcu, flz, pav PR: 116263 Tested on: pointyhat Approved by: portmgr (pav)
3.0.4 28 Jan 2007 09:07:47	kris	Use libtool port instead of included one to avoid objformat a.out botch
3.0.4 22 Jan 2006 08:23:41	edwin	SHA256ify Approved by: krion@
3.0.4 22 Jan 2006 01:29:10	edwin	Replace ugly "@unexec rmdir %D... 2>/dev/null \|\| true" with @dirrmtry Approved by: krion@ PR: ports/88711 (related)
3.0.4 21 Jul 2005 22:51:49	girgen	Welcome back to libpgeasy. It was once a part of the standard distribution (up to 7.2), but now lives its own life. Naturally, we should have a port for it :-) Official information: Pgeasy is a PostgreSQL API that is a cleaner interface to the libpq library, more like an SQL 4GL interface. Approved by: ade, seanc (implicit)

Number of commits found: 25

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? Security Policy Privacy Blog Contact

Search
Enter Keywords: more...

Latest Vulnerabilities

vscode	Oct 11
firefox	Oct 10
firefox-esr	Oct 10
gitlab	Oct 10
chromium	Oct 09
chromium	Oct 09
gitea	Oct 09
powerdns-recursor	Oct 09
ungoogled-chromium	Oct 09
ungoogled-chromium	Oct 09
unbound	Oct 06
zeek	Oct 05
firefox	Oct 03
firefox-esr	Oct 03
jenkins	Oct 03

17 vulnerabilities affecting 405 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities

Last processed:
2024-10-11 08:15:50 UTC

Ports
Home Categories Deleted ports Sanity Test Failures Newsfeeds

Statistics

Graphs
NEW Graphs (Javascript)

Calculated hourly:

Port count	32889
Broken	101
Deprecated	169
Ignore	232
Forbidden	1
Restricted	2
No CDROM	1
Vulnerable	36
Expired	9
Set to expire	134
Interactive	0
new 24 hours	0
new 48 hours	0
new 7 days	55
new fortnight	82
new month	193