create database from template requires the source database to be unused

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема create database from template requires the source database to be unused
Дата
Msg-id CAGuHJrNJyvD8zHqmWnODGvS7MAm7-yJVO81Baxz8L=5pgfMWVw@mail.gmail.com
обсуждение исходный текст
Ответы Re: create database from template requires the source database to be unused  (Craig Ringer <ringerc@ringerc.id.au>)
Re: create database from template requires the source database to be unused  (Alban Hertroys <haramrae@gmail.com>)
Список pgsql-general
Дерево обсуждения 
I am sure this is intended behavior but it seems odd (and inconvenient) to me.

create database tim_test_copy template tim_test

ERROR:  source database "tim_test" is being accessed by other users
DETAIL:  There are 1 other session(s) using the database.

I would presume only reads are required from tim_test but apparently I
have to resort to pg_dump and pg_restore to clone an active database.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Catching DETAIL and HINT
Следующее
От: Paul McGarry
Дата:
Сообщение: log_min_duration_statement modification for non superusers?