cstore_fdw and hot standby

[haiza...@gmail.com]

Hello,

Does cstore_fdw on postgres 9.4 supported by hot standby ?

If not, what the suggestion to implement high availability to application that use cstore_fdw ?

Thanks,

Hai

[Murat Tuncer]

Hello

it depends on how you plan to use cstore. 

cstore does not support postgresql replication (BDR etc) you would need to insert the same data into both master and the standby.

Would you mind sharing little bit of details on 

- nature of inserts (bulk ..)

- frequency (hourly, daily ...)

cheers

Murat

--
You received this message because you are subscribed to the Google Groups "cstore users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cstore-users...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Murat Tuncer
Software Engineer | Citus Data
mtu...@citusdata.com

[hai zamir]

Hi Murat,

Thanks for your quick respond.

I planing to \copy data every 5 minutes to cstore table, Then do an "insert select" using trigger to avoid duplication and enrichment (join with tables from mySql_fdw and local) to other cstore "daily" table.

Thanks,

Hai

--
You received this message because you are subscribed to a topic in the Google Groups "cstore users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cstore-users/ez4l_6Y6CSA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to cstore-users...@googlegroups.com.

[Murat Tuncer]

so you are doing

1 - a bulk copy into a cstore table cs1 (every 5 minutes)

2 - join cstore table cs1. local table a, mysql_fdw b (probably keep this in a table c)

3 - bulk insert into cstore table cs2

If you only need the contents of cs2 to be replicated, you could perform 1 and 2, then export/insert contents of result 2 into a standby postgres. 

if you need both on standby, I think you would have to perform all steps in both servers.

[חי זמיר‎]

Hi,  

You mean copy result of step 2 into "regular" Postgres table that replicate to standby?

Thanks

Hai

‫ב-8 באוק 2015, בשעה 14:49, ‏Murat Tuncer <mtu...@citusdata.com> כתב/ה:‬

[Murat Tuncer]

not exactly but very close

either replicate that table to standby and insert into a cstore table cs2

or manually copy it to stanby than insert it into daily cstore table cs2