[Pgcluster-general] RPMs

[Tarhon-Onu Victor]

On Mon, 26 Feb 2007, John Gardner wrote:

> We're about to put together a relatively simple 2 node PostgreSQL
> cluster using pgCluster.  Now, I've installed Postgres using the latest
> 8.2.3 RPM package, and I am looking for an RPM package of pgCluster but
> there doesn't seem to be any around, (there was some discussion on the
> list back in March 2006 but no resolution) so my question is three-fold...

 	Hi guys,

 	As I promised a few days ago I've put together some PostgreSQL 
RPMs with the pgcluster patch added.

> 1) Are there any RPMs of pgCluster available for RHEL 4/CentOS 4.4?

 	I think you can use the ones I've created for Fedora Core 6.

> 2) If not, how easy it to build an RPM (I know that in Slony-I it's just
> a case of ./configure, make rpm - is it the same with pgCluster?)

 	Download the source RPM you need (for 8.2.3 in your case), and 
then:

rpmbuild --rebuild --target i686 --define 'runselftest 0' --define \
'dist .centos44' postgresql-8.2.3-2.fc6.1BB.pgcluster1.7.0rc4.src.rpm

 	Please note that you'll have to have installed some development 
packages required by postgresql package in order to rebuild the package 
successfully.

 	After you'll install the postgresql-pgcluster package, the pglb 
and pgreplicate configuration files should be placed in 
/var/lib/pgsql/clusterconf/ and the work files are in the 
/var/lib/pgsql/clusterdata/ directory. Of course, you can change their 
locations from /etc/sysconfig/{pglb,pgreplicate} configuration files.
 	The postgresql rc script has a new option: startrecover - which is 
obvious what it does.

 	You can find the Postgresql pgcluster RPMs I've build at:

 	http://blackblue.iasi.rdsnet.ro/pgcluster-rpms/

 	Note that the binaries are build on a FC6 system, so please 
rebuild them if necessary using the source RPMs.
 	Also, if you intend to migrate from postgresql 8.1.x to 8.2.x on a 
RPM based distro you will also need to rebuild some packages like php (for 
php-pgsql), bind-sdb, apr-util, dovecot, mod_auth_pgsql, perl-DBD-Pg, 
libdbi and postgresql-jdbc - I think, maybe others also.

 	Please let me know if you find any bugs or if you have any 
suggestions.

 	Enjoy!

-- 
Victor Tarhon-Onu
Lead Systems Administrator
ActiveMedia Technology
http://www.activemediatech.com
.............................................................................
This communication contains information that is confidential and may also be
privileged. It is for the exclusive use of the intended recipient(s). If you
are not the intended recipient(s) please note that any form of distribution,
copying or use of this communication or the information in it is strictly
prohibited and may be unlawful. If you have received this communication in
error kindly notify the sender immediately and delete it from your system.