On Thu, Mar 26, 2015 at 04:32:00PM +0100, Sven Geggus wrote:
We need to somehow save the state of the osm database to be able to apply
future changes. This is currently done using a few tables in the target
database. However these tables are not needed for map rendering and are
consuming
No idea if this is an option for you or not, but if you make tables
unlogged they won't generate WAL and therefore won't be replicated:
http://rhaas.blogspot.ca/2010/05/global-temporary-and-unlogged-tables.html
Of course unlogged tables have several drawbacks to carefully consider.
On
Sven Geggus li...@fuchsschwanzdomain.de wrote:
So here is my question:
Would it be possible to have a setup, where one master data database will
act in the above matter (still running osm2pgsl) but will also provide
publicly availabe data for log-shipping standby servers?
We would need
Hello,
I have a question regarding log-shipping replication, but let me first
explain what I currently do.
Usually Openstreetmap Tile Servers are currently set up using a
PostgreSQL/Postgis Database which stores the data need for rendering raster
map-tiles.
After the initial import of a