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
[EMAIL PROTECTED]
http://www.linuxlouis.net
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
