On 08/19/10 20:19, Benjamin Smith wrote:
> On Wednesday, August 18, 2010 04:58:08 pm Joshua D. Drake wrote:
>> Well if you are just using it for updates to the schema etc... you
>> should only need to launch a single connection to each database to make
>> those changes.
>
> And that's exactly the
On Wednesday, August 18, 2010 04:58:08 pm Joshua D. Drake wrote:
> Well if you are just using it for updates to the schema etc... you
> should only need to launch a single connection to each database to make
> those changes.
And that's exactly the problem. On each server, we have at least dozens o
On Wednesday, August 18, 2010 08:40:21 pm Adrian von Bidder wrote:
> Heyho!
>
> On Thursday 19 August 2010 01.32:06 Benjamin Smith wrote:
> > This way we can be sure that either all the databases are in synch, or
> > that we need to rollback the program patch/update.
>
> I guess this might be mo
On Thu, Aug 19, 2010 at 05:40:21AM +0200, Adrian von Bidder wrote:
> On Thursday 19 August 2010 01.32:06 Benjamin Smith wrote:
> > This way we can be sure that either all the databases are in synch, or
> > that we need to rollback the program patch/update.
>
> I guess this might be more a hack th
Heyho!
On Thursday 19 August 2010 01.32:06 Benjamin Smith wrote:
> This way we can be sure that either all the databases are in synch, or
> that we need to rollback the program patch/update.
I guess this might be more a hack than a solution: do the updates in batches
and use 2pc: first connect
On Wed, 2010-08-18 at 16:32 -0700, Benjamin Smith wrote:
> So far, it's been a dream, but now, as we continue to grow, we're starting to
> reach connection limits per server. Short of raising the number of
> simultaneous connections, is there a way to run all the transactions for a
> single ser
Hello Benjamin,
On Wed, 2010-08-18 at 16:32 -0700, Benjamin Smith wrote:
> Is there a way to update a number of databases hosted on a single server
> without opening a separate psql connection to each database?
I believe you are more interested in applying an atomic update for all
databases rat
On Aug 18, 2010, at 4:32 PM, Benjamin Smith wrote:
> Is there a way to update a number of databases hosted on a single server
> without opening a separate psql connection to each database?
>
> We have a cluster of servers hosting an application on Postgres. Right now,
> we
> have dozens of d
Is there a way to update a number of databases hosted on a single server
without opening a separate psql connection to each database?
We have a cluster of servers hosting an application on Postgres. Right now, we
have dozens of databases per server, enough that we're starting to have
problems