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
pgp00000.pgp
Description: PGP signature
