FreshPorts -- databases/postgresql-ogr_fdw: PostgreSQL foreign data wrapper for OGR

Port details

postgresql-ogr_fdw PostgreSQL foreign data wrapper for OGR

1.1.4 databases =0 1.1.4Version of this port present on the latest quarterly branch.

Maintainer: lbartoletti@FreeBSD.org

Port Added: 2019-10-21 17:54:10

Last Update: 2024-03-01 06:40:02

Commit Hash: 294a681

License: MIT

WWW:

https://github.com/pramsey/pgsql-ogr-fdw

Description:

This PostgreSQL extension implements a Foreign Data Wrapper (FDW) for OGR. Please note that this version of ogr_fdw works with PostgreSQL 9.3+, and have some limitations: Only non-spatial query restrictions are pushed down to the OGR driver. Spatial restrictions are not pushed down. OGR connections every time. All columns are retrieved every time.

¦ ¦ ¦ ¦

Manual pages:

FreshPorts has no man page information for this port.

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

Expand this list (8 items)

Collapse this list.

bin/ogr_fdw_info
lib/postgresql/ogr_fdw.so
share/postgresql/extension/ogr_fdw--1.0--1.1.sql
share/postgresql/extension/ogr_fdw--1.1.sql
share/postgresql/extension/ogr_fdw.control
/usr/local/share/licenses/postgresql15-ogr_fdw-1.1.4/catalog.mk
/usr/local/share/licenses/postgresql15-ogr_fdw-1.1.4/LICENSE
/usr/local/share/licenses/postgresql15-ogr_fdw-1.1.4/MIT

Collapse this list.

Dependency lines:

postgresql15-ogr_fdw>0:databases/postgresql-ogr_fdw

To install the port:

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

To add the package, run one of these commands:

pkg install databases/postgresql-ogr_fdw
pkg install postgresql15-ogr_fdw

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

PKGNAME: postgresql15-ogr_fdw

Flavors: there is no flavor information for this port.

distinfo:

TIMESTAMP = 1709187900 SHA256 (pramsey-pgsql-ogr-fdw-v1.1.4_GH0.tar.gz) = 7bacb28ace465773544d76d8ad7b7bfb95245c6ad68aa2c58f785b54da93234a SIZE (pramsey-pgsql-ogr-fdw-v1.1.4_GH0.tar.gz) = 253512

Packages (timestamps in pop-ups are UTC):

postgresql12-ogr_fdw
ABI	aarch64	amd64	armv6	armv7	i386	powerpc	powerpc64	powerpc64le
FreeBSD:13:latest	-	-	1.0.12	-	-	-	1.0.12	-
FreeBSD:13:quarterly	-	-	-	-	-	-	-	-
FreeBSD:14:latest	-	-	-	-	-	-	-	-
FreeBSD:14:quarterly	-	-	-	-	-	-	-	-
FreeBSD:15:latest	-	-	n/a	-	n/a	-	-	-
FreeBSD:15:quarterly	-	-	n/a	-	n/a	-	-	-

postgresql15-ogr_fdw
ABI	aarch64	amd64	armv6	armv7	i386	powerpc	powerpc64	powerpc64le
FreeBSD:13:latest	1.1.4	1.1.4	-	1.1.4	1.1.4	-	-	-
FreeBSD:13:quarterly	1.1.4	1.1.4	-	1.1.4	1.1.4	-	1.1.3_2	1.1.3_2
FreeBSD:14:latest	1.1.4	1.1.4	-	1.1.4	1.1.4	-	-	-
FreeBSD:14:quarterly	1.1.3_2	1.1.4	-	1.1.3_2	1.1.4	-	1.1.3_2	1.1.3_2
FreeBSD:15:latest	1.1.4	1.1.4	n/a	1.1.3_2	n/a	-	1.1.3_2	1.1.3_2
FreeBSD:15:quarterly	-	-	n/a	-	n/a	-	-	-

Dependencies

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

Build dependencies:

gmake>=4.3 : devel/gmake
postgres : databases/postgresql15-server

Runtime dependencies:

postgres : databases/postgresql15-server

Library dependencies:

libgdal.so : graphics/gdal

There are no ports dependent upon this port

Configuration Options:

No options to configure

Options name:

databases_postgresql-ogr_fdw

USES:

gmake pgsql:11+

FreshPorts was unable to extract/find any pkg message

Master Sites:

Expand this list (1 items)

Collapse this list.

https://codeload.github.com/pramsey/pgsql-ogr-fdw/tar.gz/v1.1.4?dummy=/

Collapse this list.

Notes from UPDATING

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

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

Expand this list (1 items)

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: 20

Commit	Credits	Log message
Commit History - (may be incomplete: for full details, see links to repositories near top of page)
1.1.4 01 Mar 2024 06:40:02	Loïc Bartoletti (lbartoletti)	databases/postgresql-ogr_fdw: bump to 1.1.4
1.1.3_2 27 May 2023 04:08:05	Po-Chuan Hsieh (sunpoet)	graphics/gdal: Update to 3.7.0 Changes: https://github.com/OSGeo/gdal/releases https://github.com/OSGeo/gdal/blob/release/3.7/NEWS.md
1.1.3_1 23 Apr 2023 09:09:58	Gerald Pfeifer (gerald)	*: Bump PORTREVISIONs for math/mpc update to 1.3.1
1.1.3 15 Apr 2023 13:14:58	Muhammad Moinur Rahman (bofh)	/: Remove pointers to EOLed pgsql versions - Remove dotted pgsql versions Approved by: portmgr
1.1.3 27 Oct 2022 08:04:57	Loïc Bartoletti (lbartoletti)	databases/postgresql-ogr_fdw: Update to 1.1.3
1.1.2 29 Sep 2022 04:58:53	Loïc Bartoletti (lbartoletti)	databases/postgresql-ogr_fdw: Update to 1.1.2 Release notes: https://github.com/pramsey/pgsql-ogr-fdw/releases/tag/v1.1.2
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)
1.1.1_1 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 )
1.1.1_1 12 Aug 2022 14:46:53	Dima Panov (fluffy)	/: bump all consumers after recent boost upgrade
1.1.1 11 Feb 2022 18:17:24	Loïc Bartoletti (lbartoletti)	databases/postgresql-ogr_fdw: Update to 1.1.1 - Support PostgreSQL 14
1.1.0_1 07 Apr 2021 08:09:01	Mathieu Arnold (mat)	One more small cleanup, forgotten yesterday. Reported by: lwhsu
1.1.0_1 06 Apr 2021 14:31:07	Mathieu Arnold (mat)	Remove # $FreeBSD$ from Makefiles.
1.1.0_1 23 Feb 2021 05:58:36	lbartoletti	graphics/gdal: Set the default options as a workable set - reinstate r552962 (was reverted in r553000) - remove pkg-message from qgis and qgis-ltr - Bump PORTREVSION on all consumers PR: 224004 Approved by: portmgr
1.1.0 06 Feb 2021 07:13:22	lbartoletti	databases/postgresql-ogr_fdw: Update to 1.1.0 - New options for handling multi-sheet worksheets - Better handling of character encoding for sources with non-UTF8 data - Functions to display version info and list available drivers
1.0.12 29 May 2020 18:43:35	lbartoletti	databases/postgresql-ogr_fdw: Update to 1.0.12 Approved by: tcberner (mentor) Differential Revision: https://reviews.freebsd.org/D24998
1.0.9_1 22 Jan 2020 06:02:25	sunpoet	Bump PORTREVISION for graphics/gdal shlib change
1.0.9 14 Jan 2020 21:45:15	lbartoletti	Change my mail address to lbartoletti@FreeBSD.org Approved by: tcberner (mentor) Differential Revision: https://reviews.freebsd.org/D23169
1.0.9 22 Nov 2019 09:26:01	joneum	Update to 1.0.9 Changelog: https://github.com/pramsey/pgsql-ogr-fdw/releases/tag/v1.0.9 PR: 242073 Submitted by: Loic Bartoletti <lbartoletti@tuxfamily.org> (maintainer) Sponsored by: Netzkommune GmbH
1.0.8 28 Oct 2019 20:52:14	amdmi3	- Fix pkg-plist PR: 241527 Submitted by: lbartoletti@tuxfamily.org (maintainer) Reported by: olgeni
1.0.8 21 Oct 2019 17:54:03	amdmi3	Add databases/postgresql-ogr_fdw: PostgreSQL foreign data wrapper for OGR This PostgreSQL extension implements a Foreign Data Wrapper (FDW) for OGR. Please note that this version of mysql_fdw works with PostgreSQL 9.3+, and have some limitations: Only non-spatial query restrictions are pushed down to the OGR driver. Spatial restrictions are not pushed down. OGR connections every time. All columns are retrieved every time. WWW: https://github.com/pramsey/pgsql-ogr-fdw PR: 241199 Submitted by: lbartoletti@tuxfamily.org

Number of commits found: 20

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

ruby31	Apr 23
ruby32	Apr 23
ruby33	Apr 23
sdl2_sound	Apr 22
chromium	Apr 21
ungoogled-chromium	Apr 21
clamav	Apr 19
jenkins	Apr 19
jenkins-lts	Apr 19
electron27	Apr 18
electron28	Apr 18
electron29	Apr 18
filezilla	Apr 16
php81	Apr 16
php82	Apr 16

16 vulnerabilities affecting 271 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities

Last processed:
2024-04-23 14:57:51 UTC

Ports
Home Categories Deleted ports Sanity Test Failures Newsfeeds

Statistics

Graphs
NEW Graphs (Javascript)

Calculated hourly:

Port count	32217
Broken	86
Deprecated	179
Ignore	217
Forbidden	2
Restricted	2
No CDROM	1
Vulnerable	40
Expired	5
Set to expire	153
Interactive	0
new 24 hours	1
new 48 hours	3
new 7 days	15
new fortnight	24
new month	125

Get notified when packages are built