Re: [Postgres-xc-general] coordinator deaths

[Shavais Z. <sh...@gm...>]

When you want to add a port number with pg_ctl, be sure to use quotes with
> -o, like:
> -o "-p $PORT"
>
> The XC documentation is not perfect, if you could point to the page and
> the paragraph where you had doubts I can try to have a look and correct the
> doc if necessary.
>

After looking at the docs of alternatives to XC that I've looked at, I
appreciate the XC docs a lot.

The pg_ctl --help screen says  "-o OPTIONS".  I feel a bit dumb for not
considering that the options probably need to be in quotes.


>
>
>> The pgbench utility wasn't installed, but I finally found it and
>> installed it.  I notice that it somehow left a bunch of idle connection
>> processes behind after exiting.  Would those get reused, or is that a
>> problem with pgbench?  (I restarted postgres-xc and they went away, but.
>>  Just wondering.)
>>
> The connection pooling of XC is made to maintain connections between nodes
> as it consumes a bunch of ressources to create connections on the fly for
> each transaction.
> You can however drop those connections with CLEAN CONNECTION, command
> specific to XC:
> http://postgres-xc.sourceforge.net/docs/1_0/sql-cleanconnection.html
>
>
Nice..