Re: [GENERAL] PG under OpenVZ?

2012-11-13 Thread Benjamin Henrion
e to be careful to have swap activated, and SHMPAGES tuned, as well as SHMMAX. Otherwise it runs like a charm. -- Benjamin Henrion FFII Brussels - +32-484-566109 - +32-2-3500762 "In July 2005, after several failed attempts to legalise software patents in Europe, the patent establishment change

Re: [GENERAL] Incremental backup with RSYNC or something?

2011-11-24 Thread Benjamin Henrion
SCSI > too, in RAID 10, but the dump takes over 2-3 hours (60 GB database) > and the CPU consumption during this time is huge. I wrote a bunch of shell scripts tools to backup postgres 9.1 with rsync/ccollect (another hardlink tool), I might find the time to publish it on github once I fin

[GENERAL] Split read/write queries between 2 servers (one master and one slave with streaming replication)?

2012-03-01 Thread Benjamin Henrion
Hi, I am trying pgpool2 to split read and write queries, where reads should go to the slave server (streaming replication) and writes to the master server. Anybody has a config file that works for pgpool2? Best, -- Benjamin Henrion FFII Brussels - +32-484-566109 - +32-2-3500762 "In July