Re: vPgSql

2018-08-18 Thread Dmitri Maziuk
On Sat, 18 Aug 2018 10:52:59 +1000
Tim Cross  wrote:
 
> I think pretty much all *nix systems put core shells like sh, bash, zsh
> etc in /bin (as it is guaranteed to be available immediately at boot, while 
> /usr is
> not - it could be a separate partition which isn't available until later
> in the boot process).

They do but at least solaris circa v.9 and now redhat have replaced /bin with a 
symlink to /usr/bin. Whether you get /bin/sh or /usr/bin/sh out of `which` 
depends purely on their order in your $PATH.
 
> A way to avoid platform differences is to use /usr/bin/env e.g.
> 
> #!/usr/bin/env bash

Except now you can't pass arguments to your bash. 

You can't win. Although in the case of shell scripts you can get rid of all 
bash'isms and call '/bin/sh'
-- 
Dmitri Maziuk 



Re: Upgrade/Downgrade

2018-08-23 Thread Dmitri Maziuk
On Thu, 23 Aug 2018 14:47:25 +0300
Achilleas Mantzios  wrote:

> What do you mean is not compatible? What's the problem?

As I recall there's several SETs and some other stuff that v.10 spits out that 
earlier versions do not recognize. Nothing that a little sed script can't fix 
but you need to understand what you're doing.

-- 
Dmitri Maziuk 



Re: WARNING: could not flush dirty data: Function not implemented

2018-09-03 Thread Dmitri Maziuk
On Mon, 03 Sep 2018 09:58:57 -0400
Tom Lane  wrote:

> Ravi Krishna  writes:
> >> Whee ... so you get to cope with all the bugs/idiosyncrasies of three
> >> operating system layers, not just one.  I concur that running Postgres
> >> in the underlying Windows O/S is probably a much better idea.
> 
> > Me too, but this is purely for learning and I am much more use to Linux 
> > stack then ... gasp Windows :-)
> 
> Hmm, so maybe you should install Ubuntu as the native O/S, and when
> you need Windows, run it inside a VM?
 
Between windows 10 and ubuntu 18.04, I would take a really close look at 
freebsd myself. Or at least alpine...

-- 
Dmitri Maziuk 



Re: increasing HA

2018-09-05 Thread Dmitri Maziuk
On Wed, 5 Sep 2018 13:23:41 +0200
Thomas Poty  wrote:

> At first glance, i may use for automatic failover PAF, a proxy HAproxy and
> for fencincg, i am a bit disappointed, i don't know what to do/use

How many nodes do you want run? Keep in mind that with only 2 nodes, fencing 
off the right one is by definition an undecidable problem. That's one of the 
features of the current linux HA stack that makes one want to go BSD/CARP.

And if you want to run fully distributed, you might want to look at redis in 
the first place.

-- 
Dmitri Maziuk 



Re: increasing HA

2018-09-05 Thread Dmitri Maziuk
On Wed, 5 Sep 2018 17:45:05 +0200
Thomas Poty  wrote:

> We have one master and 2 slaves so 3 nodes

So what is the "HA" that you're trying to "increase"? Are you adding a 3rd 
slave? A 2nd master? A hot standby? All of the above? 

-- 
Dmitri Maziuk 



Re: Code of Conduct plan

2018-09-16 Thread Dmitri Maziuk
On Sat, 15 Sep 2018 16:12:36 -0700
Adrian Klaver  wrote:

> https://marshmallow.readthedocs.io/en/dev/code_of_conduct.html

Personally I don't give a toss about politolosophy, I think idiocy, no matter 
how well-meaning, is still idiocy and is probably contaguious via 
"normalization of idiocy". Since "god won't save us from well-meaning people" 
and "you can't overcome stupid", the only rational option left is not to march 
with them.

-- 
Dmitri Maziuk 



Re: Code of Conduct plan

2018-09-17 Thread Dmitri Maziuk
On Sun, 16 Sep 2018 12:52:34 +
Martin Mueller  wrote:

> ... The overreach is dubious on both practical and theoretical grounds. 
> "Stick to your knitting " or the KISS principle seem good advice in this 
> context. 

Moderated mailing lists ain't been broken all these years, therefore they need 
fixing. Obviously.

-- 
Dmitri Maziuk