PostgreSQL Compressed Archive Logs in Windows

Many have blogged and offered glaringly on how to compress archive logs in PostgreSQL, I desire to share one of a short version from my end which’s on Windows. If archive storage is concern, then you can choose compressed archive logging feature in PostgreSQL. “archive_command(string)” in $PGDATA/postgresql.conf, is like a shell command to execute what’s…

ERROR: could not access file “$libdir/plpython2” – ERROR: could not access file “$libdir/plpython3”

Above error described on PG mailing as it failes to CREATE LANGUAGE plpython2u/plpython3u on PG9.3Beta.

Before doing some study on above errors I read below PG documentation link on how PostgreSQL permits to create langage plpython and how they should be configured. http://www.postgresql.org/docs/9.3/static/plpython-python23.html Its clear from above link you need to compile the binary two time…

Improvements in Slony-I 2.2.0beta

Thanks to Slony-I team for releasing Slony-I 2.2.0Beta with many enhancements on key areas. Few are mentioned here: Event capturing protocol changed for performance (sl_log_1 / sl_log_2): Earlier release, any DML(INSERT/UPDATE/DELETE) event data must store as SQL statement in two tables(sl_log_1/sl_log_2). Now, the protocol has completely modified to COPY format, as a result of this…