database changes during a pg_dump

From: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: database changes during a pg_dump
Date: 2014-12-01 14:51:58
Message-ID: 4E154FB60786D74BB4DFDC97BF991CAC06FFB418@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

If I do a

pg_dump -Fc dbname -U postgres > backup.out

to backup a database am I right to assume that any changes made to the database such as a row update that are made while the pg_dump is actually running will be captured in the resulting backup.out file?

Thanks

Austen

Austen Birchall Senior Database Administrator
Met Office FitzRoy Road Exeter EX1 3PB United Kingdom

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2014-12-01 14:59:12 Re: database changes during a pg_dump
Previous Message Erwan Tanajaya 2014-11-12 06:11:10 Re: Trigger difference in 9.0 and 9.3