Re: archive logs recovery

Поиск
Список
Период
Сортировка
От Sriram Dandapani
Тема Re: archive logs recovery
Дата
Msg-id 6992E470F12A444BB787B5C937B9D4DF05ABC4CE@ca-mail1.cis.local
обсуждение исходный текст
Ответ на archive logs recovery  ("Sriram Dandapani" <sdandapani@counterpane.com>)
Ответы Re: archive logs recovery  ("Aaron Bono" <postgresql@aranya.com>)
Список pgsql-admin
Also, the dynamic pg_hba changes work only for new connections that are
being established via jdbc. Existing connections seem to able to make
connections.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, August 31, 2006 1:37 PM
To: Sriram Dandapani
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] archive logs recovery

"Sriram Dandapani" <sdandapani@counterpane.com> writes:
> I have a very high traffic db with lots of table partitions. The only
> reliable way to drop the partitioned tables is to prevent any
> insert/select on the parent table , otherwise, the drop table locks
out
> the inserts, and strangely enough, the drop table command goes into a
> wait state. During shutdown and restart, I switch the pg_hba.conf to
> disallow client access for a brief period when the tables are dropped.

You do know you can change pg_hba.conf without a restart?

As for the drop going into a wait state, you might want to look around
for client code that's sitting idle with an open transaction.  The drop
should not block for longer than whatever is your longest transaction
touching that table.

            regards, tom lane

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

Предыдущее
От: "Sriram Dandapani"
Дата:
Сообщение: Re: archive logs recovery
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Why so long between archive calls?