Re: invalid byte sequence on restore

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Markus Wollny <Markus(dot)Wollny(at)computec(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: invalid byte sequence on restore
Date: 2008-11-14 13:03:22
Message-ID: 20081114130322.GC12777@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-11-14 13:08:06 Re: FreeBSD 7 needing to allocate lots of shared memory
Previous Message Markus Wollny 2008-11-14 12:58:04 invalid byte sequence on restore