<  *  | *** >

Pg_companion 

  • init cluster
  • start cluster
  • query cluster

Pg_companion

Pre requisite: one Postgresql (PG) instance running somewhere (the PG companion)
You can use PG driver to query SB
Query steps: PG client -> SB cluster -> SB and PG companion -> pgsql client
SB cluster will reply to pgsql client will a "mix" of SB and PG responses
Only queries compatible with PG are supported in this mode

init cluster

The goal is to create SB's data model in PG companion
02_sql> ./cluster.sh init_pg_companion;

start cluster

Start SB cluster in companion mode
02_sql> ./cluster.sh start|bounce;

query cluster

Query SB using PG client