Above shown is an overview about Slony-I Asynchronous replication in short. For more information,Slony-I documentation is your best friend :). Let’s start with replication methods, in perltools method,you need to configure slony at the time of source installation to enable built-in perl scripts. These scripts start with “SLONIK_” and they are designed to carry replication administrative tasks. My demo for two methods shell(slonik) & Perl is on Localhost Single instance(5432) with two databases Master & Slave replicating one table “rep_table”. Continue reading →
PostgreSQL Processes are very few and countable like, writer process, wal writer proces,stats collector,autovacuum process,syslogger process,archiver process & daemon postmaster. If replication enabled then there will be wal sender & wal receiver process. In my trainings, I use to show process information by executing “ps -ef | grep postgres”, but how could I show the same on Solaris. So, I checked with Solaris Documentation and found its very simple and easy to get the process names as linux. Continue reading →
Slony-1 2.1 has very good fixes and new features like adding Bulk tables, improvement on WAIT FOR with Merge Set/Move Set, support for TRUNCATE on replicating tables and many more. Am using Slony-I 2.0.7, so thought of upgrading it to latest version. Upgrading Slony-I is very simple and it can be achievable in few steps. My upgrade procedure assumes there is already Master/Slave setup with Slony 2.0.7. Backup Plan: Backup the existing slony schema (_slonyschema) of master/slave Backup the OLD Slony Binaries Backup all initially creates slony configuration files. Continue reading →
PostgresPlus Advance Server 9.1(PPAS) isEnterpriseDBproduct, which comes with enterprise features as additional with community PostgreSQL. Most of the contrib modules(pgfoundry) can be pluged into this product using Stackbuilder. However,currently Pl/Proxy is not bundled or downloadable with Stack-builder. So,here is how you can compile the Pl/Proxy with PPAS 9.1. Download Pl/Proxy. wget http://pgfoundry.org/frs/download.php/3274/plproxy-2.4.tar.gz tar -xvf plproxy-2.4.tar.gz make PG_CONFIG=/opt/PostgresPlus/9.1AS/bin/pg_config make intall PG_CONFIG=/opt/PostgresPlus/9.1AS/bin/pg_config Note: Flex & Bison must be installed before compiling pl/proxy. Continue reading →
Currently am working on Migrations from Oracle to PostgreSQL. Though am DBA, these days am learning a bit on Developer track too … :) Let’s see a small feature of Oracle and a similar way in PostgreSQL. Autonomous Transaction,what is it ? An autonomous transaction is an independent transaction that is initiated by another transaction, and executes without interfering with the parent transaction. When an autonomous transaction is called, the originating transaction gets suspended. Continue reading →