Re: Howto: Using PITR recovery for standby replication
От | Benjamin Krajmalnik |
---|---|
Тема | Re: Howto: Using PITR recovery for standby replication |
Дата | |
Msg-id | 8511B4970E0D124898E973DF496F9B4357E0F5@stash.stackdump.local обсуждение исходный текст |
Ответ на | Slony1 or DRBD for replication ? (Pierre LEBRECH <pierre.lebrech@laposte.net>) |
Ответы |
Re: Howto: Using PITR recovery for standby replication
(Alvaro Herrera <alvherre@commandprompt.com>)
|
Список | pgsql-admin |
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thu 4/20/2006 9:09 PM
To: Benjamin Krajmalnik
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Howto: Using PITR recovery for standby replication
"Benjamin Krajmalnik" <kraj@illumen.com> writes:
> I have tried using pg_dump, but discovered that the backup was not a =
> consistent backup.
Really?
> Back to the problem I faced when testing backups with pg_dump, it =
> appears that the backup was not a consistent backup of the data. For =
> example, sequences which are used by some tables bo longer held the =
> correct values (the tables now held higher values),
Sequences are non-transactional, so pg_dump might well capture a higher
value of the sequence counter than is reflected in any table row, but
there are numerous other ways by which a gap can appear in the set of
sequence values. That's not a bug. If you've got real discrepancies
in pg_dump's output, a lot of us would like to know about 'em.
regards, tom lane
В списке pgsql-admin по дате отправления:
Следующее
От: Alvaro HerreraДата:
Сообщение: Re: Howto: Using PITR recovery for standby replication