Re: transactions included in hot backup

Thanks for your help!

> Alex Pollock
> WFSC Data Services District
> Database Administration



-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: Monday, June 16, 2003 4:56 PM
To: Alex.H.Pollock@WellsFargo.COM
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] transactions included in hot backup


Alex.H.Pollock@WellsFargo.COM wrote:
> Does pg_dump include all transactions that are committed before the hot
> backup is finished in the database backup?  If not, what transactions are
> included in the hot backup?

All transactions at _start_ of backup, per database.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073