Skip to main content

Posts

Showing posts from September, 2011

pgpoolAdmin, web interface for pgpool

--preparation--
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... ^_^

--1--
first we need to download pgpooladmin from here, extrak and copy or move to http directory( for exp : /var/www) 
$wget http://pgfoundry.org/frs/download.php/2964/pgpoolAdmin-3.0.3.tar.gz $tar zxvf pgpoolAdmin-3.0.3.tar.gz $sudo cp -Rf pgpoolAdmin-3.0.3 /var/www/test
 --2--
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

--preparation--
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.
 --1--
 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 = '1.1.1.1' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '' backend_hostname1 = '1.1.1.2' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '' edit config file o…