Re: Forgot to dump old data before re-installing machine

Поиск
Список
Период
Сортировка
Искать
От
Dave Page
Тема
Re: Forgot to dump old data before re-installing machine
Дата
Msg-id
937d27e10801180847u7573276as57e824d1d6827e61@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine "Gurjeet Singh" <singh.gurjeet@gmail.com>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Martijn van Oosterhout <kleptog@svana.org>
Re: Forgot to dump old data before re-installing machine Richard Huxton <dev@archonet.com>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Thomas Pundt <mlists@rp-online.de>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine "Dave Page" <dpage@postgresql.org>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine "Dave Page" <dpage@postgresql.org>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine "Dave Page" <dpage@postgresql.org>
Re: Forgot to dump old data before re-installing machine Peter Eisentraut <peter_e@gmx.net>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine "Dave Page" <dpage@postgresql.org>
Re: Forgot to dump old data before re-installing machine Alvaro Herrera <alvherre@commandprompt.com>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine "Dave Page" <dpage@postgresql.org>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine "Dave Page" <dpage@postgresql.org>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine "Dave Page" <dpage@postgresql.org>
Re: Forgot to dump old data before re-installing machine Greg Smith <gsmith@gregsmith.com>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine Greg Smith <gsmith@gregsmith.com>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Tom Lane <tgl@sss.pgh.pa.us>
Re: Forgot to dump old data before re-installing machine Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Martijn van Oosterhout <kleptog@svana.org>
Re: Forgot to dump old data before re-installing machine "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Forgot to dump old data before re-installing machine [solved] Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>
Re: Forgot to dump old data before re-installing machine Martijn van Oosterhout <kleptog@svana.org>
Re: Forgot to dump old data before re-installing machine "Scott Marlowe" <scott.marlowe@gmail.com>
On 18/01/2008, Peter Eisentraut  wrote:
> Am Freitag, 18. Januar 2008 schrieb Dave Page:
> > It got figured out when someone who knew what they were looking for
> > peeked at the byte ordering in a file which for all we knew at the
> > time might have been damaged anyway
>
> What might be better is if we had an explicit endianness mark in pg_control
> rather than relying on users discovering endianness problems by seemingly
> corrupted version numbers.

Seems reasonable to me. Obviously I'd mixed up the datetime/time_t
issues I ran into previously, so having the configure options as well
would be largely useless.

That said, is zlib used by toast or do we have some other code for
that? If it is used for that, do we record it's presence or absence in
pg_control?

/D
В списке pgsql-general по дате отправления
От: Jan de Visser
Дата:
Сообщение: transactionid lock type?
От: Peter Wilson
Дата:
Сообщение: Re: Replication Using Triggers
FAQ