On Thu, Dec 16, 2004 at 02:56:12PM +0100, peter pilsl wrote:
> I did a new initdb and recovered from the backup, but there is one minor
> database that was not in the backup for weeks (blame me), so I would be
> very happy if there is way to start postgres on the old datadir and
> retrieve the data.
>
> Isnt there any way to let postgres ignore the whole XLog and just give
> what it has? The table in questions sure was not updated while the
> server crashed.
Yeah, on 7.1.3 try with contrib/pg_resetxlog.
--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"El realista sabe lo que quiere; el idealista quiere lo que sabe" (Anónimo)