database-level locking

Поиск
Список
Период
Сортировка
От Karl DeBisschop
Тема database-level locking
Дата
Msg-id 199903191857.NAA18366@skillet.infoplease.com
обсуждение исходный текст
Ответы Re: [GENERAL] database-level locking  (Marcin Grondecki <ojciec@mtl.pl>)
Список pgsql-general
Does anyone know a way to lock a database under postgres while
leaving available the other databases managed by postmaster?

We are running postgreSQL 6.4.2 on our web site for content serving
and for registration information.  There are 4 separate databases
served by postmatser to support these functions.

Every now and the we have manually deleted temporary sort files to
keep disk usage in control.  We'd like to automate this process, but
to do so safely we need to ensure that no sorts are being run while we
delete the accumualted files.  Thus, we'd like to lock a database,
delete its accumulated wastage, unlock the database, and move on to
the next.

Of course the better solution would be if postgres was always able to
identify and clear out its excesses, but we have found that is not the
case.

Karl

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

Предыдущее
От: pete collins
Дата:
Сообщение: trouble with sum
Следующее
От: Marcin Grondecki
Дата:
Сообщение: Re: [GENERAL] trouble with sum