Re: transactions included in hot backup - Mailing list pgsql-admin

From Alex.H.Pollock@WellsFargo.COM
Subject Re: transactions included in hot backup
Date
Msg-id B3302CC87392D511A2AC0001FA7E5BA0075C52FF@xcem-casfo-17.wellsfargo.com
Whole thread Raw
In response to transactions included in hot backup  (Alex.H.Pollock@WellsFargo.COM)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: transactions included in hot backup
Next
From: "yangming"
Date:
Subject: about view and release locks