From: | Mike <ipso(at)snappymail(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 9.4+ partial log-shipping possible? |
Date: | 2015-03-27 16:24:17 |
Message-ID: | 55158431.2000608@snappymail.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 03/26/2015 08:32 AM, Sven Geggus wrote:
> 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 complete OSM dataset it is possible to
> replicate changes to this database using cyclic calls to openstreetmaps own
> tool called osm2pgsql.
>
> Unfortunately there is one major drawback with this approach:
>
> 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 by far the most disk space (still somewhat expensive on SSD)!
>
> 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 to be able to explicitely specify the tables to be replicated
> or the other way round explicitely exclude a couple of them. If this helps
> it would be possible to separate them by tablespaces.
>
> Regards
>
> Sven
>
--
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Vincent Veyron | 2015-03-27 16:37:42 | Re: Populating missing dates in postgresql data |
Previous Message | David G. Johnston | 2015-03-27 15:33:36 | Re: Populating missing dates in postgresql data |