Hello.
I was speaking with my colleague about PostgreSQL maintenance and he asked
me a question which I wasn't able to answer.
Is it possible to make a full DB backup (one database, say 'test') online
and be sure, that after restoring it it'll contain ALL and ONLY data at the
time of backuping routine start.
I want to be sure, that nothing additional will get into dump after I'll
start pg_dump.
Is this possible? Or, may be, such behaviour is on by default (I
didn't find anything concerning my problem in the docs about pg_dump).
Thank you.
--
Victor Yegorov