Well, at first I figured I must have sent the wrong postgresql.conf on since the nodes were answering and they must have been listening. However apperently somehow they were answering even with that setting commented out. I have uncommented listen_address and restarted postgresql on the nodes, however the load ballancer acts the same. Nothing logged and just this in the sts file: Wed Mar 19 09:23:09 2008 port(5432) host:node1 initialize Wed Mar 19 09:23:09 2008 port(5432) host:node2 initialize /usr/local/bin/pglb -D /etc/pg_cluster/ -nvl 2008-03-19 09:23:09 [7880] DEBUG:PGRset_status_on_cluster_tbl():host:node1 port:5432 max:200 use:0 status1 2008-03-19 09:23:09 [7880] DEBUG:PGRset_status_on_cluster_tbl():host:node2 port:5432 max:200 use:0 status1 2008-03-19 09:23:09 [7880] DEBUG:init_pglb():Child_Tbl size is[482400] The load ballancer system runs just the load ballancer, not a postgresql cluster.
On Wed, 2008-03-19 at 03:50 +0100, A. Mitani wrote: > Hi Sean, > > According to your postgresql.conf, the "listen_addresses" tag is commented > out. > Please remove '#' from the "listen_addresses" tag. > > Regards, > > ----- Original Message ----- > From: "Sean Brown" <[EMAIL PROTECTED]> > To: [email protected] > Sent: 2008年3月18日 22時33分49秒 (GMT+0900) Asia/Tokyo > Subject: Re: [Pgcluster-general] Load Ballancer problems > > Ok, here it is again since it has been a day and it hasn't shown up. > Hopefully the first one got lost and I haven't just posted twice. > > Node1 cluster.conf: > <Replicate_Server_Info> > <Host_Name> node1 </Host_Name> > <Port> 8001 </Port> > <Recovery_Port> 8101 </Recovery_Port> > </Replicate_Server_Info> > <Replicate_Server_Info> > <Host_Name> node2 </Host_Name> > <Port> 8001 </Port> > <Recovery_Port> 8101 </Recovery_Port> > </Replicate_Server_Info> > #------------------------------------------------------------- > # set Cluster DB Server information > #------------------------------------------------------------- > <Host_Name> node1 </Host_Name> > <Recovery_Port> 7001 </Recovery_Port> > <Rsync_Path> /usr/bin/rsync </Rsync_Path> > <Rsync_Option> ssh -2 </Rsync_Option> > <Rsync_Compress> yes </Rsync_Compress> > <Pg_Dump_Path> /usr/local/pgsql/bin/pg_dump </Pg_Dump_Path> > <When_Stand_Alone> read_only </When_Stand_Alone> > <Replication_Timeout> 1min </Replication_Timeout> > <LifeCheck_Timeout> 3s </LifeCheck_Timeout> > <LifeCheck_Interval> 11s </LifeCheck_Interval> > <Error_Log_File>/var/log/postgres/cluster_err.log</Error_Log_File> > > Node2 cluster.conf: > <Replicate_Server_Info> > <Host_Name> node1 </Host_Name> > <Port> 8001 </Port> > <Recovery_Port> 8101 </Recovery_Port> > </Replicate_Server_Info> > <Replicate_Server_Info> > <Host_Name> node2 </Host_Name> > <Port> 8001 </Port> > <Recovery_Port> 8101 </Recovery_Port> > </Replicate_Server_Info> > #------------------------------------------------------------- > # set Cluster DB Server information > #------------------------------------------------------------- > <Host_Name> node2 </Host_Name> > <Recovery_Port> 7001 </Recovery_Port> > <Rsync_Path> /usr/bin/rsync </Rsync_Path> > <Rsync_Option> ssh -2 </Rsync_Option> > <Rsync_Compress> yes </Rsync_Compress> > <Pg_Dump_Path> /usr/local/pgsql/bin/pg_dump </Pg_Dump_Path> > <When_Stand_Alone> read_only </When_Stand_Alone> > <Replication_Timeout> 1min </Replication_Timeout> > <LifeCheck_Timeout> 3s </LifeCheck_Timeout> > <LifeCheck_Interval> 11s </LifeCheck_Interval> > <Error_Log_File>/var/log/postgres/cluster_err.log</Error_Log_File> > > pg_hba.conf and postgresql.conf are the same between each node, I'll > attach postgres.conf since it is much longer. > > pg_hba.conf: > # "local" is for Unix domain socket connections only > local all all trust > # IPv4 local connections: > host all all 127.0.0.1/32 trust > # IPv6 local connections: > host all all ::1/128 trust > #Trust for PGCluster > host all all 192.168.0.0/24 trust > host all postgres 10.10.0.47/32 trust > > host all all 10.10.0.0/16 md5 > > > > On Sat, 2008-03-15 at 10:24 +0900, [EMAIL PROTECTED] wrote: > > Hi, > > > > Could you show the setting of each cluster DB (i.e pg_hba.conf, > > postgresql.conf and cluster.conf). > > > > Regards, > > > > -- original message -- > > From: Sean Brown<[EMAIL PROTECTED]> > > To: <[email protected]> > > Sent: Fri, 14 Mar 2008 16:25:24 -0400 > > Subject: [Pgcluster-general] Load Ballancer problems > > > > >I have a 2 node cluster DB up and running and replicating between each > > >other. I am now trying to get the Load Ballancer set up. Nothing gets > > >logged. I can log on to each of the postgres databases with psql from the > > >load ballancer system. > > > > > >It doesn't seem to ever mark the back end as usable: > > >/usr/local/bin/pglb -D /etc/pg_cluster/ -nv > > >2008-03-14 16:14:04 [26988] > > >DEBUG:PGRset_status_on_cluster_tbl():host:node1.domain.local port:5432 > > >max:200 use:0 status1 > > >2008-03-14 16:14:04 [26988] > > >DEBUG:PGRset_status_on_cluster_tbl():host:node2.domain.local port:5432 > > >max:200 use:0 status1 > > >2008-03-14 16:14:04 [26988] DEBUG:init_pglb():Child_Tbl size is[482400] > > > > > >It just sits there after this. > > > > > >pglb.conf: > > ><Cluster_Server_Info> > > > <Host_Name> node1.domain.local </Host_Name> > > > <Port> 5432 </Port> > > > <Max_Connect> 200 </Max_Connect> > > ></Cluster_Server_Info> > > > > > ><Cluster_Server_Info> > > > <Host_Name> node2.domain.local </Host_Name> > > > <Port> 5432 </Port> > > > <Max_Connect> 200 </Max_Connect> > > ></Cluster_Server_Info> > > > > > > > > ><Host_Name> lb.domain.local </Host_Name> > > ><Recieve_Port> 5432 </Recieve_Port> > > ><Recovery_Port> 6101 </Recovery_Port> > > ><Use_Connection_Pooling> no </Use_Connection_Pooling> > > ><Max_Cluster_Num> 200 </Max_Cluster_Num> > > ><Life_Check_Timeout> 3s <Life_Check_Timeout> > > ><Life_Check_Interval> 20s <Life_Check_Interval> > > ><Log_File_Info> > > > <File_Name> /var/log/postgres/pglb.log </File_Name> > > > <File_Size> 10M </File_Size> > > > <Rotate> 3 </Rotate> > > ></Log_File_Info> > > > > > >pglb.sts > > >Fri Mar 14 16:21:30 2008 port(5432) host:node1.domain.local initialize > > >Fri Mar 14 16:21:30 2008 port(5432) host:node2.domain.local initialize > > > > > >/etc/hosts > > >127.0.0.1 localhost.localdomain localhost > > > > > >10.10.0.45 node1.domain.local node1 > > >10.10.0.46 node2.domain.local node2 > > > > > >10.10.0.47 lb.domain.local lb > > > > > >_______________________________________________ > > >Pgcluster-general mailing list > > >[email protected] > > >http://pgfoundry.org/mailman/listinfo/pgcluster-general > > > > > > > _______________________________________________ > > Pgcluster-general mailing list > > [email protected] > > http://pgfoundry.org/mailman/listinfo/pgcluster-general > > _______________________________________________ > Pgcluster-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgcluster-general _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general
