Re: invalid byte sequence on restore - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: invalid byte sequence on restore
Date
Msg-id 20081114130322.GC12777@svana.org
Whole thread Raw
In response to invalid byte sequence on restore  ("Markus Wollny" <Markus.Wollny@computec.de>)
List pgsql-general
On Fri, Nov 14, 2008 at 01:58:04PM +0100, Markus Wollny wrote:
> Hi!
>
> I am currently struggling with a couple oif tainted bytes in one of
> our PostgreSQL 8.2 databases which I plan to move to 8.3 soon - so I
> need to dump & restore.

At some point there was a plpgsql function posted that you could run
over text columns to identify broken encodings. Terribly slow but it
looked effective.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Attachment

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: invalid byte sequence on restore
Next
From: Martijn van Oosterhout
Date:
Subject: Re: FreeBSD 7 needing to allocate lots of shared memory