Re: Running pg_dump from a slave server

Поиск
Список
Период
Сортировка
От Patrick B
Тема Re: Running pg_dump from a slave server
Дата
Msg-id CAJNY3iusgtWuxTTxwQ1VUp=vuDCV5xWZmbDQgBB5PwHjai0ZGQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Running pg_dump from a slave server  (Sameer Kumar <sameer.kumar@ashnik.com>)
Ответы Re: Running pg_dump from a slave server  (Sameer Kumar <sameer.kumar@ashnik.com>)
Список pgsql-general


But do you have statements which causes Exclusive Locks? Ignoring them in OLTP won't make your life any easier. 

(Keeping avoiding to get into 'recovery conflict' as your sole goal) If you decide to  run pg_dump from master, it would block such statements which have Exclusive locking. This would cause delays, deadlocks, livelocks etc and it might take a while for your before you can figure out what is going on.

I would say try to find out who is and why is someone creating Exclusive locks.


Yeah! The pg_dump was already running on the master... it's been running for months.. I just wanted to change now to use the slave, but it seems I can't right?

Exclusive locking - I probably have statements that causes this. Is there any way I could "track" them?

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

Предыдущее
От: Sameer Kumar
Дата:
Сообщение: Re: Running pg_dump from a slave server
Следующее
От: Venkata B Nagothi
Дата:
Сообщение: Re: Running pg_dump from a slave server