pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?

Поиск
Список
Период
Сортировка
От Jack Kerkhof
Тема pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?
Дата
Msg-id ENEIKKAEJOFHOIHMMOIDAEINEDAA.jack.kerkhof@guest-tek.com
обсуждение исходный текст
Ответы Re: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?
Список pgsql-admin
If I run pgdump, and while it is running, execute INSERT, UPDATE, DELETE
commands, what will happen to the pgdump results?

- Is pgdump all contained in a single transaction, so it just gets the
'before' data state,
- Do some of the modifications end up in the dump, but not others depending
upon where the
  dump is at that exact moment?

The pgdump documentation is not clear on these transaction concurrency
issues.

Thanks, Jack




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

Предыдущее
От: "Vickriz Buenaventuura"
Дата:
Сообщение: Re: pgadmin3 software dependencies?
Следующее
От: alvaro@audifarma.com.co
Дата:
Сообщение: SOS ---- Could you help me with postgresql.....????