The latest PgOSM Flex image now has osm2pgsql 2.0.0. Here's the quick start if you haven't tried PgOSM Flex yet!

https://pgosm-flex.com/quick-start.html

#pgosm #postgis #openstreetmap #gischat

Initial version of Windows instructions for PgOSM Flex are live! Hopefully this helps some folks out there.

https://pgosm-flex.com/windows.html

#pgosm #gischat #postgis #docker #windows

I hadn't tried Docker Desktop on Windows before today. Gotta say... pretty good experience 🤓

Julie is working on new training materials for PgOSM Flex and she wanted to run it on her Windows laptop... so we'll have a section to help Windows users in the user guide soon!! 🎉

#pgosm #docker #postgis

Huge shout out to the osm2pgsql devs! Connection volume to Postgres had gotten a bit awkward with the Flex styles when they're used the way PgOSM Flex does. Replication with the default layerset previously used 207 connections! 🤯

The same step only uses 17 now!! 🎉 (:latest on Docker Hub updated)

Details and before/after charts are in the comments of the PR for the curious 🤓

#postgis #osm2pgsql #postgres #postgresql #gischat #pgosm
https://github.com/rustprooflabs/pgosm-flex/pull/376

pgBouncer is being added to PgOSM Flex! This should help the connection load with --append workloads

It is a WIP but I *think* it is functional! Testing and feedback welcome.

This finally became possible b/c pgBouncer added support for prepared statements 🤓

#pgosm #postgis #openstreetmap #gischat

https://github.com/rustprooflabs/pgosm-flex/pull/243

PgOSM Flex is ready to go with Postgres 16 and PostGIS 3.4! 🤓 🐘 🗺️

#pgosm #postgis #postgres #postgresql #openstreetmap #gischat

https://github.com/rustprooflabs/pgosm-flex/releases/tag/0.10.2

PgOSM Flex 0.10.0 is out!

This release adds support to define custom indexing on your tables. 🎉

(Plus some bug fixes 🐛)

#pgosm #postgis #openstreetmap #postgres #postgresql #osm2pgsql

https://github.com/rustprooflabs/pgosm-flex/releases/tag/0.10.0

PgOSM Flex 0.9.0 is out! 🎉

Please read the release notes, there are ⚠️ breaking changes ⚠️ to be aware of!

This release continues using more of the newer features available in osm2pgsql

https://github.com/rustprooflabs/pgosm-flex/releases/tag/0.9.0

#pgosm #postgis #openstreetmap #gischat

PgOSM Flex 0.8.1 is out! 🤓

Okay, the big news should be that it now attempts to prevent you from hosing your own database...

However, I think the continuous improvements to the docs are more important! Now providing more guidance to decide which method to use to keep your DB updated 👍

https://pgosm-flex.com/data-updates.html

#pgosm #postgis #postgres #openstreetmap

Hey PgOSM Flex Users! Can you help test / code review in the next couple of weeks? I'll be updating the PR I just started. Moving DB deploy away from Sqitch...

Yes... this will fix a bug I recently introduced...

More importantly -- this continues the move toward being more flexible! This change has been brewing for a while 🤓

https://github.com/rustprooflabs/pgosm-flex/pull/324

#pgosm #openstreetmap #postgis

PgOSM Flex 0.8.0 will be out before too long. I'm pretty excited about it!

#pgosm is the easiest way to load high quality #OpenStreetMap data to #postgis... it is:

* Reliable
* Easy to try out
* Easy to load/update to prod
* Low friction software updates

#gischat #postgres #postgresql

https://blog.rustprooflabs.com/2023/04/pgosm-flex-production-openstreetmap

Do you use PgOSM Flex without using the Docker image? Not just "Postgres outside docker" but completely no Docker. I want to hear from you!

⚠️⚠️⚠️

Considering a breaking change

https://github.com/rustprooflabs/pgosm-flex/issues/304

#pgosm #postgis #openstreetmap

PgOSM Flex docs has a new look and a new home! 🤓📖

https://pgosm-flex.com/

This is a huge step forward from the bare collection of MD scripts. The 0.7.0 release made a thorough review necessary anyway.

Now to see if I can avoid breaking GH Pages...

#pgosm #postgis #openstreetmap #documentation

Woot! osm2pgsql 1.8.0 is out! 🎉

PgOSM Flex is already using the new index support! Before now we had to create indexes in post-processing SQL, which was harder to keep consistent.

With index creation defined in the Lua styles, we should be able to provide granular control over index creation... 🤓

#openstreetmap #postgis #pgosm

https://osm2pgsql.org/news/2023/01/28/release-1.8.0.html

PgOSM Flex 0.6.3 is out!

You can use SP-GIST indexes w/ --sp-index

Also, the --apend option is moving to --replication. Setting the stage for some breaking changes coming in 0.7.0.

https://github.com/rustprooflabs/pgosm-flex/releases/tag/0.6.3

#pgosm #postgis #openstreetmap #gischat

PgOSM Flex has a new option!

Use --sp-gist to create SP-GIST indexes instead of standard GIST.

It's in the latest Docker image now, expect a tagged 0.6.3 release before long. 🤓

#pgosm #postgis #openstreetmap #gischat

https://github.com/rustprooflabs/pgosm-flex/pull/280

Another proposed **breaking change** to PgOSM Flex. Feedback welcome!

#pgosm #postgis #openstreetmap

https://github.com/rustprooflabs/pgosm-flex/issues/275#issuecomment-1340362190

PgOSM Flex 0.6.2 is out!

This release includes a bug fix from a new contributor! 🙏

Fixed: --append with --input-file

It won't be long until append mode is the recommended approach! 🎉 🤓

#gischat #postgis #openstreetmap #pgosm

https://github.com/rustprooflabs/pgosm-flex/releases/tag/0.6.2