Re: "template1" being accessed by other users

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 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"
>
> It is unclear what is using template1 at that time, logs say nothing but
> that doesn't mean it isn't happening.
>
> Can createdb block until template1 is available? Again, there's no human
> sitting at the box to intervene. This must complete, eventually.
>
> Thanks,
> Mike
>

--
Louis Gonzales
louis(dot)gonzales(at)linuxlouis(dot)net
http://www.linuxlouis.net