[Pgcluster-general] Load Ballancer problems
Sean Brown
sbrown at eaglepress.com
Wed Mar 19 21:48:54 UTC 2008
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" <sbrown at eaglepress.com>
> To: pgcluster-general at pgfoundry.org
> 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, mitani at sraw.co.jp 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<sbrown at eaglepress.com>
> > To: <pgcluster-general at pgfoundry.org>
> > 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
> > >Pgcluster-general at pgfoundry.org
> > >http://pgfoundry.org/mailman/listinfo/pgcluster-general
> > >
> >
> > _______________________________________________
> > Pgcluster-general mailing list
> > Pgcluster-general at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pgcluster-general
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
More information about the Pgcluster-general
mailing list