Re: [GENERAL] 9.4+ partial log-shipping possible?

2015-03-27 Thread Andrew Sullivan
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

Re: [GENERAL] 9.4+ partial log-shipping possible?

2015-03-27 Thread Mike
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

Re: [GENERAL] 9.4+ partial log-shipping possible?

2015-03-26 Thread Andreas Kretschmer
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

[GENERAL] 9.4+ partial log-shipping possible?

2015-03-26 Thread Sven Geggus
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