[ADMIN] limiting number of connections from specific host or by user

2006-05-10 Thread Kenji Morishige
We are having a problem where we are running out of connections due to a in-house tool that creates abnormal amount of connections due to fluctuating loads that we cannot control. Ideally, the tool could be re-written to take into account for those situations, but due to its complexity we don't

Re: [ADMIN] limiting number of connections from specific host or by user

2006-05-10 Thread Kenji Morishige
sweet! Thanks for the great info. We have been planning to upgrade when we find a good window. Thank you! -Kenji On Wed, May 10, 2006 at 01:57:24PM -0600, Michael Fuhr wrote: > On Wed, May 10, 2006 at 12:06:46PM -0700, Kenji Morishige wrote: > > Is there any way from Postgr

[ADMIN] Warm-Backup configuration question

2007-08-23 Thread Kenji Morishige
I've got 2 identical servers configured exactly the same way, except for some minor differences for the WAL logging directories. I have both machines set up as a NFS server and client, so that the WAL archive gets written out to the local filesystem of the backup machine depending on which role th

Re: [ADMIN] Warm-Backup configuration question

2007-08-24 Thread Kenji Morishige
Hmm. I recently installed 8.2.4 out of ports (FreeBSD) and didn't see that file in contrib. I'd like to take a look at it. Kenji On Fri, Aug 24, 2007 at 07:18:12AM +0300, Mikko Partio wrote: > > > On 8/24/07, Kenji Morishige <[EMAIL PROTECTED]> wrote: > >