source: subversion/applications/utils/whichdiff/README @ 34714

Last change on this file since 34714 was 29923, checked in by frederik, 6 years ago

whichdiff utility finds the right state.txt for a given node ID

File size: 614 bytes
Line 
1whichdiff.pl is a Perl script that finds the state.txt file to use
2for minutely replication based on the highest node ID in your database.
3
4Simply do a
5
6select max(id) from planet_osm_nodes
7
8or if you're using flatnodes, osm2pgsql will report the highest node ID
9in the flat storage when run.
10
11Then run whichdiff.pl with the node id as the only argument, and it will
12give you the contents for your state.txt (by default it will use that
13state.txt file from the server which is two minutes before the one in
14which your latest node was generated).
15
16Written by Frederik Ramm <frederik@remote.org>, public domain.
Note: See TracBrowser for help on using the repository browser.