Current status

postgresql-ogr_fdw PostgreSQL foreign data wrapper for OGR

1.1.0_1 databases =0 1.0.12Version of this port present on the latest quarterly branch.

Maintainer: lbartoletti@FreeBSD.org

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

Last Update: 2021-02-23 05:58:36

SVN Revision: 566369

License: MIT

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. WWW: https://github.com/pramsey/pgsql-ogr-fdw

SVNWeb : Homepage

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

Expand this list (8 items)

Collapse this list.

1. bin/ogr_fdw_info
2. lib/postgresql/ogr_fdw.so
3. share/postgresql/extension/ogr_fdw--1.0--1.1.sql
4. share/postgresql/extension/ogr_fdw--1.1.sql
5. share/postgresql/extension/ogr_fdw.control
6. /usr/local/share/licenses/postgresql12-ogr_fdw-1.1.0_1/catalog.mk
7. /usr/local/share/licenses/postgresql12-ogr_fdw-1.1.0_1/LICENSE
8. /usr/local/share/licenses/postgresql12-ogr_fdw-1.1.0_1/MIT

Collapse this list.

Dependency lines:

• postgresql12-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: pkg install postgresql12-ogr_fdw

PKGNAME: postgresql12-ogr_fdw

Flavors: there is no flavor information for this port.

distinfo:

TIMESTAMP = 1612594371 SHA256 (pramsey-pgsql-ogr-fdw-v1.1.0_GH0.tar.gz) = 688729fb38c320b70e7ddeb629a9472efd3d2a7227816740d215c863958cff33 SIZE (pramsey-pgsql-ogr-fdw-v1.1.0_GH0.tar.gz) = 252808

Dependencies

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

Build dependencies:

1. gmake>=4.3 : devel/gmake
2. postgres : databases/postgresql12-server

Runtime dependencies:

1. postgres : databases/postgresql12-server

Library dependencies:

1. libgdal.so : graphics/gdal

There are no ports dependent upon this port

Configuration Options

No options to configure

USES:

gmake pgsql:9.3+

Master Sites:

Expand this list (1 items)

Collapse this list.
1. https://codeload.github.com/pramsey/pgsql-ogr-fdw/tar.gz/v1.1.0?dummy=/
Collapse this list.

• 2020-09-21

  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 11 to 12.
    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 11.9, your
    files are named according to this.
  
    # service postgresql stop
    # pkg create postgresql11-server postgresql11-contrib
    # mkdir /tmp/pg-upgrade
    # tar xf postgresql11-server-11.9.txz -C /tmp/pg-upgrade
    # tar xf postgresql11-contrib-11.9.txz -C /tmp/pg-upgrade
    # pkg delete -f databases/postgresql11-server databases/postgresql11-contrib databases/postgresql11-client
  
    Now update PostgreSQL:
  
      pkg user:
      # pkg install databases/postgresql12-server databases/postgresql12-contrib
      # pkg upgrade
  
      Portmaster users:
      # portmaster databases/postgresql12-server databases/postgresql12-contrib
      # portmaster -a
  
      Portupgrade users:
      # portinstall databases/postgresql12-server databases/postgresql12-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/data12 -U postgres"
    # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data11/ -B /usr/local/bin/ -D /var/db/postgres/data12/ -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 (4 items)Collapse this list.



• 2019-08-29

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

  Author: tz@FreeBSD.org

  Reason: 
    The default version of PostgreSQL has been switched from 9.5 to 11.
    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 9.5.19, your
    files are named according to this.
  
    # service postgresql stop
    # pkg create postgresql95-server postgresql95-contrib
    # mkdir /tmp/pg-upgrade
    # tar xf postgresql95-server-9.5.19.txz -C /tmp/pg-upgrade
    # tar xf postgresql95-contrib-9.5.19.txz -C /tmp/pg-upgrade
    # pkg delete -f databases/postgresql95-server databases/postgresql95-contrib databases/postgresql95-client
  
    Now update PostgreSQL:
  
      pkg user:
      # pkg install databases/postgresql11-server databases/postgresql11-contrib
      # pkg upgrade
  
      Portmaster users:
      # portmaster databases/postgresql11-server databases/postgresql11-contrib
      # portmaster -a
  
      Portupgrade users:
      # portinstall databases/postgresql11-server databases/postgresql11-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/data11 -U pgsql"
    # chown -R postgres /usr/local/pgsql/data/
    # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /usr/local/pgsql/data/ -B /usr/local/bin/ -D /var/db/postgres/data11/ -U pgsql "
  
    Now the migration is finished. You can start PostgreSQL again with:
  
    # service postgresql start
  
    ATTENTION:
    1) The default user changed from "pgsql" to "postgres". The migration steps above preserve
       the "pgsql" database user while the database daemon is now executed as the "postgres" FreeBSD user.
    2) The default data dir changed from "/usr/local/pgsql/data/" to "/var/db/postgres/data11/"
    3) If you use non-default initdb options, you have to adjust the initdb-command accordingly
  
  

• 2017-06-22

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

  Author: tz@FreeBSD.org

  Reason: 
    The default version of PostgreSQL has been switched from 9.3 to 9.5.
    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 9.3.12, your
    files are named according to this.
  
    # service postgresql stop
    # pkg create postgresql93-server postgresql93-contrib
    # mkdir /tmp/pg-upgrade
    # tar xf postgresql93-server-9.3.17.txz -C /tmp/pg-upgrade
    # tar xf postgresql93-contrib-9.3.17.txz -C /tmp/pg-upgrade
    # mv /usr/local/pgsql/data /usr/local/pgsql/data93
    # pkg delete -f databases/postgresql93-server databases/postgresql93-contrib databases/postgresql93-client
  
    Now update PostgreSQL:
  
      pkg user:
      # pkg install databases/postgresql95-server databases/postgresql95-contrib
      # pkg upgrade
  
      Portmaster users:
      # portmaster databases/postgresql95-server databases/postgresql95-contrib
      # portmaster -a
  
      Portupgrade users:
      # portinstall databases/postgresql95-server databases/postgresql95-contrib
      # portupgrade -a
  
    After installing the new PostgreSQL version you need to convert
    all your databases to new version:
  
    # service postgresql initdb
    # su -l pgsql -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /usr/local/pgsql/data93/ -B /usr/local/bin/ -D /usr/local/pgsql/data/"
  
    Now the migration is finished. You can start PostgreSQL again with:
  
    # service postgresql start
  
  

• 2014-02-11

  Affects: users of lang/php* databases/postgresql* databases/mysql* www/apache*

  Author: mat@FreeBSD.org

  Reason: 
    The default versions of lang/php*, databases/postgresql*,
    databases/mysql* and www/apache* have been changed to support the
    new DEFAULT_VERSIONS variable.
  
    DEFAULT_APACHE_VER, DEFAULT_MYSQL_VER, DEFAULT_PGSQL_VER,
    DEFAULT_FPC_VER and DEFAULT_PHP_VER are now deprecated.  You can use
    the new DEFAULT_VERSIONS variable like this:
  
    DEFAULT_VERSIONS=php=5.5 mysql=5.6 apache=2.4
  
  

Collapse this list.

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

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

databases/postgresql-ogr_fdw: Update to 1.0.12

Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D24998

Bump PORTREVISION for graphics/gdal shlib change

Change my mail address to lbartoletti@FreeBSD.org

Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D23169

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

- Fix pkg-plist

PR:		241527
Submitted by:	lbartoletti@tuxfamily.org (maintainer)
Reported by:	olgeni

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

13 vulnerabilities affecting 98 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities

Last updated:
2021-02-27 01:52:12