[postgis-tickets] [SCM] postgis.net branch hugo updated. c2cb1e6b332fdae42153b249699b458af9a44863
git at osgeo.org
git at osgeo.org
Sun Feb 27 23:16:33 PST 2022
This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "postgis.net".
The branch, hugo has been updated
via c2cb1e6b332fdae42153b249699b458af9a44863 (commit)
from ce28b62f632b9e85a29c7b8152aa3d1775fea21b (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit c2cb1e6b332fdae42153b249699b458af9a44863
Author: Regina Obe <lr at pcorp.us>
Date: Mon Feb 28 02:16:28 2022 -0500
Change to markdown code syntax instead of hugo specific. Shows correctly in gitea that way
diff --git a/content/pages/install.md b/content/pages/install.md
index d5ad47b..da8986d 100644
--- a/content/pages/install.md
+++ b/content/pages/install.md
@@ -78,7 +78,7 @@ Connect to your database with `psql` or PgAdmin. Run the following SQL.
You need only install the features you want:
-{{< highlight postgres>}}
+```postgres
-- Enable PostGIS (as of 3.0 contains just geometry/geography)
CREATE EXTENSION postgis;
-- enable raster support (for 3+)
@@ -97,7 +97,7 @@ CREATE EXTENSION address_standardizer;
CREATE EXTENSION address_standardizer_data_us;
-- Enable US Tiger Geocoder
CREATE EXTENSION postgis_tiger_geocoder;
-{{< / highlight >}}
+```
## Upgrading PostGIS
To upgrade PostGIS, you first have to install the latest binaries and then upgrade each database you have PostGIS installed in
@@ -107,14 +107,16 @@ You can upgrade from 2.0 to 2.1, 2.2 et.c using this approach. To go from 1.* to
Refer to [PostGIS install](/docs/postgis_installation.html#install_short_version) for more extensive instructions.
Note: that as of PostGIS 2.1.3 and PostGIS 2.0.6, you need to set [environment variables](/posts/2014/05/19/postgis-2.0.6_and_2.1.3) to get full features.
-{{< highlight postgres>}}-- Upgrade PostGIS (includes raster) to latest version
+```postgres
+-- Upgrade PostGIS (includes raster) to latest version
ALTER EXTENSION postgis UPDATE;
ALTER EXTENSION postgis_topology UPDATE;
-{{< / highlight >}}
+```
or to a specific version
-{{< highlight postgres>}}-- Upgrade PostGIS (includes raster)
+```postgres
+-- Upgrade PostGIS (includes raster)
ALTER EXTENSION postgis
UPDATE TO "{{< loc postgis.version>}}";
-- Upgrade Topology
@@ -124,14 +126,15 @@ ALTER EXTENSION postgis_topology
-- Upgrade US Tiger Geocoder
ALTER EXTENSION postgis_tiger_geocoder
UPDATE TO "{{< loc "postgis.version">}}";
-{{< / highlight >}}
+```
## Spatial SQL
See the [documentation](/documentation) for more guidance.
-{{< highlight postgres>}}-- Create table with spatial column
+```postgres
+-- Create table with spatial column
CREATE TABLE mytable (
id SERIAL PRIMARY KEY,
geom GEOMETRY(Point, 26910),
@@ -155,5 +158,6 @@ WHERE ST_DWithin(
geom,
ST_GeomFromText('POINT(0 0)', 26910),
1000
-);{{< / highlight >}}
+);
+```
{{< /columns >}}
diff --git a/content/pages/support.md b/content/pages/support.md
index c14bb85..f58322c 100644
--- a/content/pages/support.md
+++ b/content/pages/support.md
@@ -16,10 +16,10 @@ Bugs are reported and managed in a [ticket tracker](http://trac.osgeo.org/postgi
3. In your report *include explicit instructions* to replicate your issue. The best tickets include the *exact SQL* necessary to replicate a problem. Eg. "Run this SQL and the back-end crashes." or "Run this SQL and the answer is (a), but it should be (b)."
4. If you can test older versions of PostGIS for your problem, please do. On your ticket, note the earliest version the problem appears.
5. For the versions where you can replicate the problem, note the operating system, and the output of the SQL
- {{< highlight postgres>}}
+ ```postgres
SELECT version() || ' '
|| postgis_full_version();
-{{< / highlight >}}
+```
Please, do not use the ticket tracker to ask for help, use the [users mailing list](http://lists.osgeo.org/mailman/listinfo/postgis-users) for that.
diff --git a/content/post/2021/12-18_postgis-3.2.0.md b/content/post/2021/12-18_postgis-3.2.0.md
index 823bd7d..570ab0e 100644
--- a/content/post/2021/12-18_postgis-3.2.0.md
+++ b/content/post/2021/12-18_postgis-3.2.0.md
@@ -70,18 +70,18 @@ View all [closed tickets for 3.2.0][1].
After installing the binaries or after running pg_upgrade:
For upgrading from PostGIS 3.0, do the following which will upgrade all your postgis extensions.
-{{< highlight postgres>}}
+```postgres
SELECT postgis_extensions_upgrade();
-{{< / highlight >}}
+```
For PostGIS 2.5 and below do:
-{{< highlight postgres>}}
+```postgres
ALTER EXTENSION postgis UPDATE;
SELECT postgis_extensions_upgrade();
SELECT postgis_extensions_upgrade();
-{{< / highlight >}}
+```
[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.2.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2022/01-14_tip-upgrading-raster-from-2-3.md b/content/post/2022/01-14_tip-upgrading-raster-from-2-3.md
index bf7937a..431127d 100644
--- a/content/post/2022/01-14_tip-upgrading-raster-from-2-3.md
+++ b/content/post/2022/01-14_tip-upgrading-raster-from-2-3.md
@@ -27,27 +27,27 @@ Regardless which version of PostGIS you are coming from, you should install the
<!-- pagebreak -->
-{{< highlight postgres>}}
+```postgres
-- this step only needed for PostGIS < 2.5.4
ALTER EXTENSION postgis UPDATE;
-- Do for all PostGIS 2.*
SELECT postgis_extensions_upgrade();
SELECT postgis_extensions_upgrade();
-{{< / highlight >}}
+```
If you have no need for raster support and have no tables currently
with rasters, you can then drop the extension as follows:
-{{< highlight postgres>}}
+```postgres
DROP EXTENSION postgis_raster;
-{{< / highlight >}}
+```
So you may be wondering, the oddity of running twice:
-{{< highlight postgres>}}
+```postgres
SELECT postgis_extensions_upgrade();
-{{< / highlight >}}
+```
This is because, the first run, unbundles the raster support from the `postgis` extension making it a loose baggage of functons and types.
diff --git a/content/post/2022/02-02_postgis-3.0.5.md b/content/post/2022/02-02_postgis-3.0.5.md
index feaa936..5b53923 100644
--- a/content/post/2022/02-02_postgis-3.0.5.md
+++ b/content/post/2022/02-02_postgis-3.0.5.md
@@ -31,18 +31,18 @@ This release is a bug fix release, addressing issues found in the previous 3.0 r
After installing the binaries or after running pg_upgrade:
For upgrading from PostGIS 3.0, do the following which will upgrade all your postgis extensions.
-{{< highlight postgres>}}
+```postgres
SELECT postgis_extensions_upgrade();
-{{< / highlight >}}
+```
For PostGIS 2.5 and below do:
-{{< highlight postgres>}}
+```postgres
ALTER EXTENSION postgis UPDATE;
SELECT postgis_extensions_upgrade();
SELECT postgis_extensions_upgrade();
-{{< / highlight >}}
+```
If you come across any issues, feel free to report via our [ticket tracker](https://trac.osgeo.org/postgis)
or [mailing list](https://lists.osgeo.org/listinfo/postgis-users) with details
diff --git a/content/post/2022/02-12_postgis-3.2.1.md b/content/post/2022/02-12_postgis-3.2.1.md
index 45e3194..203ea40 100644
--- a/content/post/2022/02-12_postgis-3.2.1.md
+++ b/content/post/2022/02-12_postgis-3.2.1.md
@@ -42,18 +42,18 @@ After installing the binaries or after running pg_upgrade:
For PostGIS 3.2, 3.1, 3.0
do below which will upgrade all your postgis extensions.
-{{< highlight postgres>}}
+```postgres
SELECT postgis_extensions_upgrade();
-{{< / highlight >}}
+```
For PostGIS 2.5 and below do:
-{{< highlight postgres>}}
+```postgres
ALTER EXTENSION postgis UPDATE;
SELECT postgis_extensions_upgrade();
SELECT postgis_extensions_upgrade();
-{{< / highlight >}}
+```
If you come across any issues, feel free to report via our [ticket tracker](https://trac.osgeo.org/postgis)
or [mailing list](https://lists.osgeo.org/listinfo/postgis-users) with details
-----------------------------------------------------------------------
Summary of changes:
content/pages/install.md | 20 ++++++++++++--------
content/pages/support.md | 4 ++--
content/post/2021/12-18_postgis-3.2.0.md | 8 ++++----
.../post/2022/01-14_tip-upgrading-raster-from-2-3.md | 12 ++++++------
content/post/2022/02-02_postgis-3.0.5.md | 8 ++++----
content/post/2022/02-12_postgis-3.2.1.md | 8 ++++----
6 files changed, 32 insertions(+), 28 deletions(-)
hooks/post-receive
--
postgis.net
More information about the postgis-tickets
mailing list