Postgres Pro
Downloads
Home   >   mailing lists

database changes during a pg_dump - Mailing list pgsql-novice

From Birchall, Austen
Subject database changes during a pg_dump
Date
Msg-id 4E154FB60786D74BB4DFDC97BF991CAC06FFB418@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk
Whole thread Raw
Responses Re: database changes during a pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view

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

 

pgsql-novice by date:

Previous
From: Erwan Tanajaya
Date:
Subject: Re: Trigger difference in 9.0 and 9.3
Next
From: Tom Lane
Date:
Subject: Re: database changes during a pg_dump