Обсуждение: transactions included in hot backup

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?

Thanks!

Alex Pollock
WFSC Data Services District
Database Administration

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

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