Re: Portworx snapshots

2018-10-28 Thread Stephen Frost
Greetings, * Ghislain ROUVIGNAC (g...@sylob.com) wrote: > Portworx says that on a running PostgreSQL it can: > >- replicate volumes for failover >- take snapshots of volumes >- backup volumes The downside with any snapshot-style approach is that it means that when you have a failure,

Re: Question about partition table

2018-10-28 Thread Thomas Boussekey
Hello Yuxia, As time partitioning is a natively available, I recommend you to use time-partitioning, as it is. You can find below an example I used to subpartition my transaction table by quaterly partition. I have a repository table named miniexport.tby_part_followup to pilot partition creation.

Re: Enabling bdr in multiple databases on the same postgresql instance/cluster

2018-10-28 Thread Martín Marqués
El 23/10/18 a las 10:24, Daniel Fink (PDF) escribió: > > I already have a running cluster of BDR nodes. > > Now we want to add an additional database on the same hosts. > > Can I just create a new database and then create/join nodes as in this > description: > > http://bdr-project.org/docs/1.0.

Re: Ltree: set of allowed charcters is limited to [A-Za-z0-9_]. Could the dash "-" be included?

2018-10-28 Thread joernbs
Hello David, I think this is a misunderstanding. The seperator in ltree is the dot (.) , of cause I did not asked to change that. I asked about to expand allowed characters in the ltree-string [A-Za-z0-9_] to [a-zA-Z0-9_/- ] including dash(-), slash(/) and whitespace( ), common charcaters in wordi