Re: [Postgres-xc-general] Any Virtual Box images to test postgres-xc?

[Michael P. <mic...@gm...>]

On 2012/08/01, at 22:28, Benjamin Henrion <bh...@ud...> wrote:

> On Fri, Jul 27, 2012 at 6:09 PM, Joshua D. Drake <jd...@co...> wrote:
>> 
>> Hello,
>> 
>> That would be very helpful. Thank you for offering.
> 
> I just installed postgres-xc debian package that's available in SID in
> an openvz container, now I have this stuff running:
> 
> ========================================================================
> root@sid /var/lib/postgres-xc [13]# ps aux
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> root         1  0.0  0.0  10588   852 ?        Ss   15:20   0:00 init [2]
> root       911  0.0  0.0  52584  1624 ?        Sl   15:20   0:00
> /usr/sbin/rsyslogd -c5
> root       922  0.0  0.0  18816   852 ?        Ss   15:20   0:00 /usr/sbin/cron
> root       929  0.0  0.0  18644   624 ?        Ss   15:20   0:00 vzctl: pts/0
> root       930  0.0  0.0  17788  2008 pts/0    Ss   15:20   0:00 -bash
> 101       8083  0.3  0.1 101552  9140 ?        S    15:24   0:00
> /usr/bin/postgres -C -D /var/lib/postgres-xc/coord
> 101       8093  0.0  0.0 101536  1608 ?        Ss   15:24   0:00
> postgres: pooler process
> 101       8094  0.0  0.0 101536  1984 ?        Ss   15:24   0:00
> postgres: writer process
> 101       8095  0.0  0.0 101536  1812 ?        Ss   15:24   0:00
> postgres: wal writer process
> 101       8096  0.0  0.0 102416  3232 ?        Ss   15:24   0:00
> postgres: autovacuum launcher process
> 101       8097  0.0  0.0  69496  1700 ?        Ss   15:24   0:00
> postgres: stats collector process
> 101       8127  0.3  0.1 101552  9140 ?        S    15:24   0:00
> /usr/bin/postgres -X -D /var/lib/postgres-xc/datanode1
> 101       8135  0.0  0.0 101536  1988 ?        Ss   15:24   0:00
> postgres: writer process
> 101       8136  0.0  0.0 101536  1784 ?        Ss   15:24   0:00
> postgres: wal writer process
> 101       8137  0.0  0.0 102284  2776 ?        Ss   15:24   0:00
> postgres: autovacuum launcher process
> 101       8138  0.0  0.0  69496  1636 ?        Ss   15:24   0:00
> postgres: stats collector process
> 101       8145  0.3  0.1 101552  9136 ?        S    15:24   0:00
> /usr/bin/postgres -X -D /var/lib/postgres-xc/datanode2
> 101       8153  0.0  0.0 101536  1984 ?        Ss   15:24   0:00
> postgres: writer process
> 101       8154  0.0  0.0 101536  1780 ?        Ss   15:24   0:00
> postgres: wal writer process
> 101       8155  0.0  0.0 102284  2772 ?        Ss   15:24   0:00
> postgres: autovacuum launcher process
> 101       8156  0.0  0.0  69496  1632 ?        Ss   15:24   0:00
> postgres: stats collector process
> root      8781  0.0  0.0  17784  1984 pts/0    S    15:27   0:00 bash
> root      8792  0.0  0.0  15236  1136 pts/0    R+   15:29   0:00 ps aux
> root@sid /var/lib/postgres-xc [14]#
> ========================================================================
> 
> If anybody is interested in a copy of the openvz container (basically
> a rootfs), let me know, I will push it somewhere.
That would be cool!
> 
> From the debian package, how do I configure another box so that the
> two databases are in master-master mode?
I am sure Vladimir knows about that, I am not using the Debian packages at all.

Thanks, 
Michael
> 
> Best,
> 
> --
> Benjamin Henrion <bhenrion at ffii.org>
> FFII Brussels - +32-484-566109 - +32-2-3500762
> "In July 2005, after several failed attempts to legalise software
> patents in Europe, the patent establishment changed its strategy.
> Instead of explicitly seeking to sanction the patentability of
> software, they are now seeking to create a central European patent
> court, which would establish and enforce patentability rules in their
> favor, without any possibility of correction by competing courts or
> democratically elected legislators."