Le blog de Jean David TECHER, un Réunionnais à Saint-Priest/Lyon

Trois hommes s'en allèrent dans le désert
 Seules deux s'éjourneront dans le cimetière...
 Le troisème en échappera 
 car pour là
 n'a pas encore sonné l'heure du gla.
 
 C'est ici dans l'ouest sauvage
 qu'il rencontra celle que l'on appelle femme.
 Tous deux s'aimèrent et se marièrent
 jusqu'au début..
 Jusqu'au début de la grande guerre.
 
 Reconverti dans le droit chemin,
 il se mit à boire comme un bon à rien.
 Sa femme cette belle putain s'été barrée
 en emportant avec elle son butin.
 
 
 Femme et enfant furent assassinées...
 Le ciel et la terre mille fois furent retournées.
 La gâchette la toujours protégée.
 Mais parfois la vie
 contre-soi peut se retournée.
 
 Lorsq'il la retrouva, elle subit tous les supplices.
 Mais de ses crimes, il répondit devant la justice.
 Le jour où on l'incarcéra,
 Il entendit...
 Il entendit raisoner le gla.
 
 Finalement avec ou sans pognon,
 La vie ne lui avait pas valu 
 d'être ce bon truand.

Two days ago, Steve Singer published on Slony Web Site new release candidates. Content of the mail sent to Slony mailing-list

I have packaged release candidates for minor updates to multiple Slony
branches.

1.2.23 RC1
===========
- Bug #195 - make slon_quote_* functions immutable
- Bug #209 - dollar quoting doesn't work on PG 7.4
- Bug #224 - PKEYEDTABLES misspelled in altperl script
- Bug #236 - fix misformatting of log string for timestamp
- Bug #239 - Fix FAILOVER on PG 9.0 by not querying pg_listener

http://www.slony.info/downloads/1.2/source/slony1-1.2.23.rc1.tar.bz2
http://www.slony.info/downloads/1.2/source/slony1-1.2.23.rc1-docs.tar.bz2

Unless additional maintainers from the community step up 1.2.23 is
likely to be the last 1.2.x release.

2.0.8 RC1
===========
- Bug 230 - log_timestamps was always treated as true on some platforms(AIX)
- Include additional C headers required for Postgresql 9.2(master)
- Bug 233 - Fix segfault when subscribing to a set that does not exist.
- Bug 236 :: Fix default formatting of timestamp in logs
- Add express support to recognize PostgreSQL 9.1
- Bug 255 :: Fix serialization issues when using PostgreSQL 9.1

http://www.slony.info/downloads/2.0/source/slony1-2.0.8.rc1.tar.bz2
http://www.slony.info/downloads/2.0/source/slony1-2.0.8.rc1-docs.tar.bz2

2.1.1 RC1
=============
- Bug #246 :: Include path order changes
- Bug #161 :: fix memory overrun in EXECUTE SCRIPT parser
- Bug #247 :: slony_logshipper to handle TRUNCATE commands
- Bug #249 :: Add parentheses to txid_current() in function for
              TRUNCATE logging
- slonik_drop_table and slonik_drop_sequence no longer attempt to
  return -1 on an error (invalid as a slonik exit code in 2.1)
- Bug #244 :: The CREATE SET command now requires a set id to be specified.
- Bug #255 :: Fix serialization conflict issues when using PostgreSQL 9.1.
- Bug #256 :: set_conf_option() has an extra elevel parameter on PG 9.2
- Bug #259 :: Fix TRUNCATE logging so it works with mixed case slony
clusters.

http://www.slony.info/downloads/2.1/source/slony1-2.1.1.rc1.tar.bz2
http://www.slony.info/downloads/2.1/source/slony1-2.1.1.rc1-docs.tar.bz2


I hope to release actual releases in a little over a week (if no
problmems are found).  If any testers/packages plan on looking at the
release candidates but need more time then they should ask.

Here are the required instructions

1. Install Slony 1.2.23

Notice: all binaries will be install in /opt/PostgresPlus/8.3R2AS/Slony/1.2.23 so we can be sure not to replace Slony's binaries 1.2.11 bundled with EnterpriseDB.

rm -rf tmp
mkdir tmp
cd tmp

SLONY_ROOT_PATH="/opt/PostgresPlus/8.3R2AS/Slony/1.2.23";

[ -d "${SLONY_ROOT_PATH}" ] && { echo "* Destroy ${SLONY_ROOT_PATH}";rm -rf ${SLONY_ROOT_PATH}; }
mkdir -pv ${SLONY_ROOT_PATH};
ln -s /opt/PostgresPlus/8.3R2AS/dbserver/lib ${SLONY_ROOT_PATH}/lib;
				 

echo "* Download  Slony sources"
#wget -q "http://git.postgresql.org/gitweb/?p=slony1-engine.git;a=snapshot;h=af01af7786f0f4f6c5c5ea991200be04a431f586;sf=tgz" -O - | tar xzf -
wget -q "http://git.postgresql.org/gitweb/?p=slony1-engine.git;a=snapshot;h=4a7f6887ef59d185be1ea421b82cc51b3ae75e1d;sf=tgz" -O - | tar xzf -
cd slony1-*

echo "* Patch for EnterpriseDB"
wget -q http://www.davidgis.fr/download/patch_EnterpriseDB.patch  -O - | patch -p1

echo "* Replace ' slon ' by ' edb-replication '"
grep -lri " slon " src/slon/ | xargs -i sed -i "s: slon : edb-replication :g" {}

echo " * Configure"
./configure -q \
--prefix=${SLONY_ROOT_PATH} \
--with-pgconfigdir=/opt/PostgresPlus/8.3R2AS/dbserver/bin/ \
--with-perlsharedir=${SLONY_ROOT_PATH}/lib \
--with-pgsharedir=${SLONY_ROOT_PATH}/share \
--with-perltools=${SLONY_ROOT_PATH}/scripts \
--with-pglibdir=${SLONY_ROOT_PATH}/lib \
--with-pgpkglibdir=${SLONY_ROOT_PATH}/lib

echo "* Put hardcoded value for '${SLONY_ROOT_PATH}/lib' instead of '\$libdir'"
grep -lriE '\$libdir' . | while read file;do sed -i 's:\$libdir:/opt/PostgresPlus/8.3R2AS/Slony/1.2.23/lib:g' $file;done


echo "* First compilation"
make -s

echo "* Fix limit for parser for slonik 10000 to 100000";
grep -lri "define YYINITDEPTH 200" . | xargs -i sed -i "s:# define YYMAXDEPTH 10000:# define YYMAXDEPTH 100000:g;s:# define YYINITDEPTH 200:# define YYINITDEPTH 10000:g" {}

echo "* Secund compilation"
make -s

echo "* Destroy Temporary Link"
rm -rf ${SLONY_ROOT_PATH};

echo "* Ready to install";

Une méthode très efficace trouvée sur le blog d'une jeune geek http://www.pakito.eu/vie-pratique/how-to-deboucher-ses-chiottes/. Comme beaucoup au début, je ne croyais pas trop à l'efficacité de sa méthode. Mais elle fonctionne du tonnerre de dieu