Re: change request: switch MM off using pgpool

2009-11-05 Thread Ricky Zhou
On 2009-11-05 03:08:15 PM, matt_dom...@dell.com wrote:
> all MM apps running on bapp1 are stalled because pgpool is hung.  MM has lots 
> of connections to pgpool, more than it can handle.  Until this is understood, 
> go back to not using pgpool for MM.
> 
> diff --git a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb 
> b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> index e17022d..1b60465 100644
> --- a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> +++ b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> @@ -15,7 +15,7 @@
>  
>  # This is for local development purposes.  It won't be used for
>  # production.
> -sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword 
> %>@db2.fedora.phx.redhat.com:/mirrormanager"
> +sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword 
> %>@db2.fedora.phx.redhat.com:5432/mirrormanager"
>  
>  # if you are using a database or table type without transactions
>  # (MySQL default, for example), you should turn off transactions
> 
> 
> --
+1

Thanks,
Ricky


pgpZJORFepu8J.pgp
Description: PGP signature
___
Fedora-infrastructure-list mailing list
Fedora-infrastructure-list@redhat.com
https://www.redhat.com/mailman/listinfo/fedora-infrastructure-list


Re: change request: switch MM off using pgpool

2009-11-05 Thread Mike McGrath


On Thu, 5 Nov 2009, matt_dom...@dell.com wrote:

> all MM apps running on bapp1 are stalled because pgpool is hung.  MM has lots 
> of connections to pgpool, more than it can handle.  Until this is understood, 
> go back to not using pgpool for MM.
>
> diff --git a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb 
> b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> index e17022d..1b60465 100644
> --- a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> +++ b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> @@ -15,7 +15,7 @@
>
>  # This is for local development purposes.  It won't be used for
>  # production.
> -sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword 
> %>@db2.fedora.phx.redhat.com:/mirrormanager"
> +sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword 
> %>@db2.fedora.phx.redhat.com:5432/mirrormanager"
>
>  # if you are using a database or table type without transactions
>  # (MySQL default, for example), you should turn off transactions
>
>

+1

-Mike

___
Fedora-infrastructure-list mailing list
Fedora-infrastructure-list@redhat.com
https://www.redhat.com/mailman/listinfo/fedora-infrastructure-list


change request: switch MM off using pgpool

2009-11-05 Thread Matt_Domsch
all MM apps running on bapp1 are stalled because pgpool is hung.  MM has lots 
of connections to pgpool, more than it can handle.  Until this is understood, 
go back to not using pgpool for MM.

diff --git a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb 
b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
index e17022d..1b60465 100644
--- a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
+++ b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
@@ -15,7 +15,7 @@
 
 # This is for local development purposes.  It won't be used for
 # production.
-sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword 
%>@db2.fedora.phx.redhat.com:/mirrormanager"
+sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword 
%>@db2.fedora.phx.redhat.com:5432/mirrormanager"
 
 # if you are using a database or table type without transactions
 # (MySQL default, for example), you should turn off transactions


--
Matt Domsch
Technology Strategist, Dell Office of the CTO
linux.dell.com & www.dell.com/linux



___
Fedora-infrastructure-list mailing list
Fedora-infrastructure-list@redhat.com
https://www.redhat.com/mailman/listinfo/fedora-infrastructure-list