notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Remember
I remember
2024-11-06 Today brought in a new category: filesystems. Sadly, the website did not process it well. I am working on that. It may take a few days.
2024-11-07 Commit processing is halted. I have a fix for the new category. It is making its way through the system.
UPDATE: the backend is processing the original filesystems commit now. It should take about an hour.
UPDATE: as of 20:30 UTC, the filesystems commit has been processed. Commit processing is now up to date.
Port details
pg_tileserv PostGIS-only tile server written in Go
1.0.11_3 databases on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 1.0.11_1Version of this port present on the latest quarterly branch.
Maintainer: lbartoletti@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2021-07-05 13:27:13
Last Update: 2024-08-09 06:24:08
Commit Hash: aa8c011
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py39-PyOpenGL, p5-Sane
License: APACHE20
WWW:
https://github.com/crunchydata/pg_tileserv/issues
Description:
pg_tileserv is a PostGIS-only tile server written in Go. By restricting itself to only using PostGIS as a data source, pg_tileserv gains the following features: - Automatic configuration. The server can discover and automatically publish as tiles sources all tables it has read access to: just point it at a PostgreSQL/PostGIS database. - Full SQL flexibility. Using function layers, the server can run any SQL to generate tile outputs. Any data processing, feature filtering, or record aggregation that can be expressed in SQL, can be exposed as parameterized tile sources. - Database security model. You can restrict access to tables and functions using standard database access control. This means you can also use advanced access control techniques, like row-level security to dynamically filter access based on the login role.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (4 items)
Collapse this list.
  1. bin/pg_tileserv
  2. /usr/local/share/licenses/pg_tileserv-1.0.11_3/catalog.mk
  3. /usr/local/share/licenses/pg_tileserv-1.0.11_3/LICENSE
  4. /usr/local/share/licenses/pg_tileserv-1.0.11_3/APACHE20
Collapse this list.
Dependency lines:
  • pg_tileserv>0:databases/pg_tileserv
To install the port:
cd /usr/ports/databases/pg_tileserv/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pg_tileserv
  • pkg install pg_tileserv
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: pg_tileserv
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1715804076 SHA256 (go/databases_pg_tileserv/pg_tileserv-v1.0.11/v1.0.11.mod) = 4c090f5b3e85be185fee48bf1aa2b21390e83748b894bdb5f43edde512a54084 SIZE (go/databases_pg_tileserv/pg_tileserv-v1.0.11/v1.0.11.mod) = 2775

Expand this list (4 items)

Collapse this list.

SHA256 (go/databases_pg_tileserv/pg_tileserv-v1.0.11/v1.0.11.zip) = 8b255cdca543c83e1c301c1f59a0987ca9168e17f47c7fd7e37f94f98698ed31 SIZE (go/databases_pg_tileserv/pg_tileserv-v1.0.11/v1.0.11.zip) = 3068750 SHA256 (go/databases_pg_tileserv/pg_tileserv-v1.0.11/golang-sys-v0.6.0_GH0.tar.gz) = b4f6d17c7a128f76169964b437cb66b3f2dbf9a33361928ec19dfecf7b03fc54 SIZE (go/databases_pg_tileserv/pg_tileserv-v1.0.11/golang-sys-v0.6.0_GH0.tar.gz) = 1434234

Collapse this list.


Packages (timestamps in pop-ups are UTC):
pg_tileserv
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest1.0.11_31.0.11_3-1.0.11_31.0.11_3---
FreeBSD:13:quarterly1.0.11_31.0.11_3-1.0.11_31.0.11_3---
FreeBSD:14:latest1.0.11_31.0.11_3-1.0.11_31.0.11_3---
FreeBSD:14:quarterly1.0.11_31.0.11_3-1.0.11_31.0.11_3---
FreeBSD:15:latest1.0.11_31.0.11_3n/a1.0.11_3n/a---
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. go121 : lang/go121
Fetch dependencies:
  1. go121 : lang/go121
  2. ca_root_nss>0 : security/ca_root_nss
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
databases_pg_tileserv
USES:
go:1.21,modules zip
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://proxy.golang.org/github.com/crunchydata/pg_tileserv/@v/
Collapse this list.

Number of commits found: 27

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
1.0.11_3
09 Aug 2024 06:24:08
commit hash: aa8c0111bfd641853f435ed69310589fccda2200commit hash: aa8c0111bfd641853f435ed69310589fccda2200commit hash: aa8c0111bfd641853f435ed69310589fccda2200commit hash: aa8c0111bfd641853f435ed69310589fccda2200 files touched by this commit
Ashish SHUKLA (ashish) search for other commits by this committer
all: Bump after lang/go121 update
1.0.11_2
03 Jul 2024 08:29:54
commit hash: c4b51c2028302d40de3907a04d99a92001bb83b1commit hash: c4b51c2028302d40de3907a04d99a92001bb83b1commit hash: c4b51c2028302d40de3907a04d99a92001bb83b1commit hash: c4b51c2028302d40de3907a04d99a92001bb83b1 files touched by this commit
Ashish SHUKLA (ashish) search for other commits by this committer
all: Bump after lang/go121 update
1.0.11_1
15 Jun 2024 09:52:17
commit hash: 746fa696a12ef1ca798e36baf087f579375b8cd1commit hash: 746fa696a12ef1ca798e36baf087f579375b8cd1commit hash: 746fa696a12ef1ca798e36baf087f579375b8cd1commit hash: 746fa696a12ef1ca798e36baf087f579375b8cd1 files touched by this commit
Ashish SHUKLA (ashish) search for other commits by this committer
all: Bump after lang/go121 update

MFH:		2024Q2
1.0.11
15 May 2024 20:31:14
commit hash: 8965b7dc612d917bfb3ea175fb8ad4a24768ab54commit hash: 8965b7dc612d917bfb3ea175fb8ad4a24768ab54commit hash: 8965b7dc612d917bfb3ea175fb8ad4a24768ab54commit hash: 8965b7dc612d917bfb3ea175fb8ad4a24768ab54 files touched by this commit
Yuri Victorovich (yuri) search for other commits by this committer
databases/pg_tileserv: Fix build by updating 1.0.9 → 1.0.11

Reported by:	fallout
Approved by:	portmgr (blanket build fix)
1.0.9_12
24 Mar 2024 14:28:56
commit hash: aa46593632c44d6eb0b28a61662b67933bd1d0cfcommit hash: aa46593632c44d6eb0b28a61662b67933bd1d0cfcommit hash: aa46593632c44d6eb0b28a61662b67933bd1d0cfcommit hash: aa46593632c44d6eb0b28a61662b67933bd1d0cf files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pg_tileserv: PIN to GO 1.20

This port deos not build at the moment unlike the other commits which I
have tested. For now comitting without tests as the other ports works
well with same changes.

There are also reports in portsfallout.

PR:		277776
Approved by:	portmgr (blanket)
1.0.9_12
01 Mar 2024 06:33:04
commit hash: a6ff744107125832a1532454fdebedc3c53f2e1acommit hash: a6ff744107125832a1532454fdebedc3c53f2e1acommit hash: a6ff744107125832a1532454fdebedc3c53f2e1acommit hash: a6ff744107125832a1532454fdebedc3c53f2e1a files touched by this commit
Loïc Bartoletti (lbartoletti) search for other commits by this committer
databases/grass7: bump to 7.8.8
1.0.9_12
11 Feb 2024 10:39:17
commit hash: 7e5aa2085f48d71be003c8ff0377bde837467291commit hash: 7e5aa2085f48d71be003c8ff0377bde837467291commit hash: 7e5aa2085f48d71be003c8ff0377bde837467291commit hash: 7e5aa2085f48d71be003c8ff0377bde837467291 files touched by this commit
Ashish SHUKLA (ashish) search for other commits by this committer
all: Bump PORTREVISION after lang/go* update

PR:		276530
1.0.9_11
07 Dec 2023 02:22:10
commit hash: 0505b712df3ae2b4bcaba00aecc7c1e9100d8609commit hash: 0505b712df3ae2b4bcaba00aecc7c1e9100d8609commit hash: 0505b712df3ae2b4bcaba00aecc7c1e9100d8609commit hash: 0505b712df3ae2b4bcaba00aecc7c1e9100d8609 files touched by this commit
Ashish SHUKLA (ashish) search for other commits by this committer
all: Bump PORTREVISION after lang/go* update

PR:		274405
1.0.9_10
08 Sep 2023 14:34:56
commit hash: 8e4bc57934f0611f59a2bfca1ddbab781572ead3commit hash: 8e4bc57934f0611f59a2bfca1ddbab781572ead3commit hash: 8e4bc57934f0611f59a2bfca1ddbab781572ead3commit hash: 8e4bc57934f0611f59a2bfca1ddbab781572ead3 files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTREVISION after lang/go* update
1.0.9_9
04 Aug 2023 14:24:50
commit hash: 09b993031a3b38ba8c33639ca40c1e3d69de67fccommit hash: 09b993031a3b38ba8c33639ca40c1e3d69de67fccommit hash: 09b993031a3b38ba8c33639ca40c1e3d69de67fccommit hash: 09b993031a3b38ba8c33639ca40c1e3d69de67fc files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTREVISION after lang/go{119,120} update
1.0.9_8
08 Apr 2023 15:13:25
commit hash: ff40d94c1d2c808f3b54fad0e0a0a18dd9c62912commit hash: ff40d94c1d2c808f3b54fad0e0a0a18dd9c62912commit hash: ff40d94c1d2c808f3b54fad0e0a0a18dd9c62912commit hash: ff40d94c1d2c808f3b54fad0e0a0a18dd9c62912 files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTREVISION after lang/go{119,120} update
1.0.9_7
21 Mar 2023 12:53:51
commit hash: ef490e6ced17806db11ffcf08e6a7685006cc404commit hash: ef490e6ced17806db11ffcf08e6a7685006cc404commit hash: ef490e6ced17806db11ffcf08e6a7685006cc404commit hash: ef490e6ced17806db11ffcf08e6a7685006cc404 files touched by this commit
Robert Clausecker (fuz) search for other commits by this committer
databases/pg_tileserv: fix build on riscv64

Bump golang.org/x/sys dependency to a version new enough
to support riscv64-freebsd.

Sponsored by:	Berliner Linux User Group e.V.
Approved by:	portmgr (build fix blanket)
Differential Revision: https://reviews.freebsd.org/D39163
1.0.9_6
09 Mar 2023 19:18:07
commit hash: 09079730e9ca1d59129935a6046cbb7ee5e4a93dcommit hash: 09079730e9ca1d59129935a6046cbb7ee5e4a93dcommit hash: 09079730e9ca1d59129935a6046cbb7ee5e4a93dcommit hash: 09079730e9ca1d59129935a6046cbb7ee5e4a93d files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTREVISION after Go ports update
1.0.9_5
15 Feb 2023 19:06:01
commit hash: 56b5ec772f679a600dabe41622c1350594628286commit hash: 56b5ec772f679a600dabe41622c1350594628286commit hash: 56b5ec772f679a600dabe41622c1350594628286commit hash: 56b5ec772f679a600dabe41622c1350594628286 files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTREVISION after lang/go{119,120} update
1.0.9_4
09 Feb 2023 21:55:23
commit hash: 2297efc51b0f75d25389b742048fb7e9b2d96f0dcommit hash: 2297efc51b0f75d25389b742048fb7e9b2d96f0dcommit hash: 2297efc51b0f75d25389b742048fb7e9b2d96f0dcommit hash: 2297efc51b0f75d25389b742048fb7e9b2d96f0d files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTREVISION after GO_DEFAULT update.
1.0.9_3
14 Jan 2023 11:31:17
commit hash: 3b383d833aadb5e3e89d8ee3db1fef37ac239af6commit hash: 3b383d833aadb5e3e89d8ee3db1fef37ac239af6commit hash: 3b383d833aadb5e3e89d8ee3db1fef37ac239af6commit hash: 3b383d833aadb5e3e89d8ee3db1fef37ac239af6 files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTVERSION after lang/go{118,119} update
1.0.9_2
11 Dec 2022 11:17:27
commit hash: d9ad1002d517a618a299e45ae70075f2cfc66d2acommit hash: d9ad1002d517a618a299e45ae70075f2cfc66d2acommit hash: d9ad1002d517a618a299e45ae70075f2cfc66d2acommit hash: d9ad1002d517a618a299e45ae70075f2cfc66d2a files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTREVISION after lang/go{118,119} update
1.0.9_1
06 Oct 2022 19:24:26
commit hash: bde51869ee0206eeaa2849d8ef28b14da59727a3commit hash: bde51869ee0206eeaa2849d8ef28b14da59727a3commit hash: bde51869ee0206eeaa2849d8ef28b14da59727a3commit hash: bde51869ee0206eeaa2849d8ef28b14da59727a3 files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTREVISION after lang/go{118,119} update
1.0.9
21 Sep 2022 10:15:25
commit hash: a017955b8735eb1330742f6ca66fcfb115db38dbcommit hash: a017955b8735eb1330742f6ca66fcfb115db38dbcommit hash: a017955b8735eb1330742f6ca66fcfb115db38dbcommit hash: a017955b8735eb1330742f6ca66fcfb115db38db files touched by this commit
Loïc Bartoletti (lbartoletti) search for other commits by this committer
databases/pg_tileserv: Update to 1.0.9
1.0.8_5
08 Sep 2022 16:33:18
commit hash: f05c98fffb232735c05ba30d43fb279085b813d7commit hash: f05c98fffb232735c05ba30d43fb279085b813d7commit hash: f05c98fffb232735c05ba30d43fb279085b813d7commit hash: f05c98fffb232735c05ba30d43fb279085b813d7 files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTREVISION after lang/go{118,119} update
07 Sep 2022 21:58:51
commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
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.0.8_4
07 Sep 2022 21:10:59
commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
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 View all of this commit message)
1.0.8_4
03 Aug 2022 21:35:13
commit hash: 4476f89764d3ee73d216c2d56df149e8d4c62c24commit hash: 4476f89764d3ee73d216c2d56df149e8d4c62c24commit hash: 4476f89764d3ee73d216c2d56df149e8d4c62c24commit hash: 4476f89764d3ee73d216c2d56df149e8d4c62c24 files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTREVISION after Go update

Bump Go ports PORTREVISION after GO_DEFAULT and lang/go118 update.
1.0.8_3
14 Jul 2022 12:46:05
commit hash: 153cb65ac8a05356245dd09d1ff48c2a6afafc5acommit hash: 153cb65ac8a05356245dd09d1ff48c2a6afafc5acommit hash: 153cb65ac8a05356245dd09d1ff48c2a6afafc5acommit hash: 153cb65ac8a05356245dd09d1ff48c2a6afafc5a files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
all: Bump PORTREVISION after lang/go{117,118} update
1.0.8_2
07 Jun 2022 21:56:10
commit hash: 309cdeccd802bb370a42e80cc4468da17c8dab35commit hash: 309cdeccd802bb370a42e80cc4468da17c8dab35commit hash: 309cdeccd802bb370a42e80cc4468da17c8dab35commit hash: 309cdeccd802bb370a42e80cc4468da17c8dab35 files touched by this commit
Dmitri Goutnik (dmgk) search for other commits by this committer
*/*: Bump port revisons after lang/go{117,118} update
1.0.8_1
30 Mar 2022 07:01:44
commit hash: d690b5102f75bf70e3cfb280a84c9f3eaf4ec653commit hash: d690b5102f75bf70e3cfb280a84c9f3eaf4ec653commit hash: d690b5102f75bf70e3cfb280a84c9f3eaf4ec653commit hash: d690b5102f75bf70e3cfb280a84c9f3eaf4ec653 files touched by this commit
Guangyuan Yang (ygy) search for other commits by this committer
*/*: Bump PORTREVISION after lang/go 1.18 update
1.0.8
05 Jul 2021 13:00:31
commit hash: 0cc2abb2de08eabc14d69611f0613c16f0c39a9acommit hash: 0cc2abb2de08eabc14d69611f0613c16f0c39a9acommit hash: 0cc2abb2de08eabc14d69611f0613c16f0c39a9acommit hash: 0cc2abb2de08eabc14d69611f0613c16f0c39a9a files touched by this commit
Loïc Bartoletti (lbartoletti) search for other commits by this committer
databases/pg_tilserv: add new port

pg_tileserv is a PostGIS-only tile server written in Go.
By restricting itself to only using PostGIS as a data source,
pg_tileserv gains the following features:

- Automatic configuration. The server can discover and
automatically publish as tiles sources all tables it has read
access to: just point it at a PostgreSQL/PostGIS database.

- Full SQL flexibility. Using function layers, the server can
run any SQL to generate tile outputs. Any data processing,
feature filtering, or record aggregation that can be expressed in SQL,
can be exposed as parameterized tile sources.

- Database security model. You can restrict access to tables and
functions using standard database access control.
This means you can also use advanced access control techniques,
like row-level security to dynamically filter access based on the
login role.

WWW: https://github.com/crunchydata/pg_tileserv/issues

Number of commits found: 27