full db locking during dump
От | Gregory Stone |
---|---|
Тема | full db locking during dump |
Дата | |
Msg-id | 20040109021103.25843.qmail@web14009.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: full db locking during dump
|
Список | pgsql-general |
I have a situation where I am doing a pg_dump from my database. I want to make sure that noone is inserting into the tables being dump during the dump. Does the MVCC architecture make it a moot point or do I need to disable insert privileges during the dumping window? If so, is there an easy way (i.e. one liner kind of thing) to do the temporary lock? I was thinking I might need to write a stored procedure to change the write privileges for the groups that have write access. Thanks, Gregory ===== -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Gregory Stone | "Suppose you were an idiot, and suppose you were guomo ( at ) yahoo.com | a member of congress; but I repeat myself." | - Mark Twain ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus
В списке pgsql-general по дате отправления: