On 4/5/2016 5:35 PM, Sameer Kumar wrote:
Or if you are using pgpool for connection pooling/load balancing, it
might connect to template1 and do health checks.
we're literally talking about maybe one connect per DAY looking at those
graphs. a spike at 500m means one connect for 2 data points
On Tue, 5 Apr 2016 14:35 Luca Ferrari, wrote:
> (sorry, back to the list)
>
> On Tue, Apr 5, 2016 at 6:11 AM, John R Pierce wrote:
> > its also possible some management software might use it as a default
> place
> > to connect so they can get a list of databases or whatever .
>
> This is probabl
(sorry, back to the list)
On Tue, Apr 5, 2016 at 6:11 AM, John R Pierce wrote:
> its also possible some management software might use it as a default place
> to connect so they can get a list of databases or whatever .
This is probably the most common case for continuos access to template1.
Lu
On 4/4/2016 9:04 PM, drum.lu...@gmail.com wrote:
I'm currently using postgres 9.2.
As you can see below, my "template1" database was being accessed:
500m is 1/2 access per whatever interval that graph is using. typically,
template1 is accessed when you do a create database if you don't specif
Not sure, but sounds like a max user connections is preventing successive
connections?
On Thu, 19 Jul 2007, Michael P. Soulier wrote:
Hi,
We're using postgres on a server where everything is automated, no human
interaction save a web interface.
I have an issue where a post-install script tr
Tom Lane wrote:
>
> Try inserting a short sleep before the createdb.
Oh, so I'd be working around a known race condition? Is there a bug open?
> For 8.3 we have
> http://archives.postgresql.org/pgsql-committers/2007-06/msg00013.php
Ok, thanks.
Mike
--
Michael P. Soulier <[EMAIL PROTECTED]>, 6
"Michael P. Soulier" <[EMAIL PROTECTED]> writes:
> I have an issue where a post-install script tries to create a database,
> and in 1 out of 10 cases I get this:
> "createdb: database creation failed: ERROR: source database "template1"
> is being accessed by other users"
Try inserting a short sle
