"template1" being accessed by other users

Поиск
Список
Период
Сортировка
От Michael P. Soulier
Тема "template1" being accessed by other users
Дата
Msg-id 469FA2C0.7010108@mitel.com
обсуждение исходный текст
Ответы Re: "template1" being accessed by other users  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: "template1" being accessed by other users  (gonzales@linuxlouis.net)
Список pgsql-general
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
--
Michael P. Soulier <michael_soulier@mitel.com>, 613-592-2122 x2522
"Any intelligent fool can make things bigger and more complex... It
takes a touch of genius - and a lot of courage to move in the opposite
direction." --Albert Einstein

В списке pgsql-general по дате отправления:

Предыдущее
От: "Kynn Jones"
Дата:
Сообщение: Re: ISO TESTS for a Pg lexer+parser
Следующее
От: Tom Lane
Дата:
Сообщение: Re: "template1" being accessed by other users