[Tile-serving] [openstreetmap/osm2pgsql] Parse conninfo string in osm2pgsql-replication (PR #1645)

Ryan Lambert notifications at github.com
Fri Feb 25 23:32:10 UTC 2022


This is an attempt to fix #1643. This updates osm2pgsql-replication to parse a conninfo string passed to the `-d` option when psycopg3 is used.  If pyscopg2 is installed on the system it fails in its current state. I glanced through the psycopg2 docs and do not see a similar functionality to what is available in the new version.  If this looks like a decent direction to head for this fix I can work on making this change not fail with psycopg2.

This now works.

```
osm2pgsql-replication status -d postgresql://myuser:mypassword@myhost/pgosm
Using replication service 'http://download.geofabrik.de/north-america/us/district-of-columbia-updates', which is at sequence 3257 ( 2022-02-24T21:21:27Z )
Replication server's most recent data is 1 day(s) 2 hour(s) 8 minute(s) old
Local database is 29 sequences behind the server, i.e. 4 week(s) 0 day(s) 23 hour(s) 59 minute(s)
Local database's most recent data is 4 week(s) 2 day(s) 2 hour(s) 8 minute(s) old
```
You can view, comment on, or merge this pull request online at:

  https://github.com/openstreetmap/osm2pgsql/pull/1645

-- Commit Summary --

  * Allow conninfo string with osm2pgsql-replication

-- File Changes --

    M scripts/osm2pgsql-replication (29)

-- Patch Links --

https://github.com/openstreetmap/osm2pgsql/pull/1645.patch
https://github.com/openstreetmap/osm2pgsql/pull/1645.diff

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/pull/1645
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/pull/1645 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220225/456621bc/attachment.htm>


More information about the Tile-serving mailing list