Re: [GENERAL] "template1" being accessed by other users

2007-07-19 Thread gonzales
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

Re: [GENERAL] "template1" being accessed by other users

2007-07-19 Thread Michael P. Soulier
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

Re: [GENERAL] "template1" being accessed by other users

2007-07-19 Thread Tom Lane
"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

[GENERAL] "template1" being accessed by other users

2007-07-19 Thread Michael P. Soulier
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