Re: Import db from 8.1.3 to 8.3.1

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Import db from 8.1.3 to 8.3.1
Date: 2008-10-23 17:29:28
Message-ID: 20081023172927.GL3413@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 23, 2008 at 08:24:12PM +0300, Otandeka Simon Peter wrote:
> Upgraded to 8.3.4 but am still getting the same error

So it isn't an error in 8.3.1. But my bet is this:

>
> On Thu, Oct 23, 2008 at 4:35 PM, Andrew Sullivan <ajs(at)commandprompt(dot)com> wrote

> >> I am trying to import db from 8.1.3 to 8.3.1 database however I get
> >> some characters \x09\x09\x09\x09.

I expect that your problem is that 8.1 allowed some characters in that
you didn't want. You probably need to use iconv to change those
characters to whatever are actually valid.

A
--
Andrew Sullivan
ajs(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-10-23 17:37:10 Re: Import db from 8.1.3 to 8.3.1
Previous Message Jack Orenstein 2008-10-23 17:27:15 Re: Postgres optimizer choosing wrong index