Skip to main content


Showing posts from September, 2011

pgpoolAdmin, web interface for pgpool

next capter of pgpool from my last post ( here), now i wanna post about a tool that can manage pgpool from web interface called pgpoolAdmin. next... enjoy the post... ^_^

first we need to download pgpooladmin from here, extrak and copy or move to http directory( for exp : /var/www) 
$wget $tar zxvf pgpoolAdmin-3.0.3.tar.gz $sudo cp -Rf pgpoolAdmin-3.0.3 /var/www/test
install pgpooladmin via web on: http://localhost/test/install

make sure owner of that file is "www-data"(of course have write akses) and check again

login with user that you create on /etc/pcp.conf (for more detail see my last post

and done.ya.. tooo.......!!!

my unity desktop

take a look at my desktop unity with conky and AWN

postgresql replication with pgpool2 on ubuntu

next capter from may last post, now we'll make repication of postgreSQL with pgpool on ubuntu. assumtion, we have 2 server with postgresql installed ( n running well ) on each server.
 first install pgpooll2, with
sudo apt-get install pgpool2--2--
 edit config file on /etc/pgpool.conf
# Host name or IP address to listen on: '*' for all, '' for no TCP/IP # connections listen_addresses = '*' # Port number for pgpool port = 5433 # Port number for pgpool communication manager pcp_port = 9898 parallel_mode = false # Replication mode replication_mode = true # Load balancing mode, i.e., all SELECTs are load balanced. # This is ignored if replication_mode is false. load_balance_mode = true backend_hostname0 = '' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '' backend_hostname1 = '' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '' edit config file o…