Menu
▾
▴
Re: [Postgres-xc-general] Any Virtual Box images to test postgres-xc?
|
From: Benjamin H. <bh...@ud...> - 2012-08-01 13:52:45
|
On Wed, Aug 1, 2012 at 3:31 PM, Michael Paquier <mic...@gm...> wrote: > > 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. Basically I end up with the following setup: http://michael.otacoo.com/postgresql-2/start-a-postgres-xc-cluster-in-more-or-less-10-commands/ Now I do not understand how master-master can work since the coordinator is still a SPOF. -- 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." |
