Re: [GENERAL] Postgres Pain Points: 1 pg_hba conf

2016-08-13 Thread Chris Travers
On Sat, Aug 13, 2016 at 9:37 PM, John R Pierce wrote: > On 8/13/2016 8:29 AM, support-tiger wrote: > >> experimented with this some more with no progress. only trust seems to >> work which is not what we want - will try some more versions with md5 but >> this is why I've called this out as such a

Re: [GENERAL] Postgres Pain Points: 1 pg_hba conf

2016-08-13 Thread John R Pierce
On 8/13/2016 8:29 AM, support-tiger wrote: experimented with this some more with no progress. only trust seems to work which is not what we want - will try some more versions with md5 but this is why I've called this out as such a pain point. show us your pg_hba.conf (sans comments), and the c

Re: [GENERAL] BDR Cluster vs DB Config

2016-08-13 Thread Martín Marqués
El 20/07/16 a las 20:06, Jonathan Eastgate escribió: > > I assume that once BDR is enabled on a database that any additional > schemas added post config are automatically included in BDR replication? All DDLs (CREATE SCHEMA ...) will be replicated to the other nodes, but if you are asking if the

Re: [GENERAL] Any reasons for 'DO' statement not returning result?

2016-08-13 Thread Francisco Olarte
On Fri, Aug 12, 2016 at 11:34 PM, Xtra Coder wrote: ... > In my particular case I'm more interested in an easy way to create complex > SELECTs that require usage of variables in the one-time through-away scripts > (some-time during experiments for implementation of functions, to see > immediate re

Re: [GENERAL] Corrupted Data ?

2016-08-13 Thread Francisco Olarte
Hi Adrian: On Fri, Aug 12, 2016 at 9:01 PM, Adrian Klaver wrote: > "Specially if this happens, you may have some slightly bad disks/ram/ > leading to this kind of problems." > > Trying to reconcile that with all the physical machine 1 VMs sharing the > same RAM and physical disk, but the error on