Thread: Import db from 8.1.3 to 8.3.1
Hi All, 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 know this is an error in 8.3.1 that was fixed in later updates however is there a way of getting around it without going all over again and remain with 8.3.1 database where I have already put alot of important data. peter.
On Thu, Oct 23, 2008 at 12:58:39PM +0300, Otandeka Simon Peter wrote: > Hi All, > > 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 know this is an error in 8.3.1 that was fixed in later updates > however is there a way of getting around it without going all over > again and remain with 8.3.1 database where I have already put alot of > important data. Why don't you use the latest 8.3.x release? You don't need a dump and restore to go from 8.3.1 to 8.3.latest. A -- Andrew Sullivan ajs@commandprompt.com +1 503 667 4564 x104 http://www.commandprompt.com/
Upgraded to 8.3.4 but am still getting the same error Anything I can do about it? On Thu, Oct 23, 2008 at 4:35 PM, Andrew Sullivan <ajs@commandprompt.com> wrote: > On Thu, Oct 23, 2008 at 12:58:39PM +0300, Otandeka Simon Peter wrote: >> Hi All, >> >> 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 know this is an error in 8.3.1 that was fixed in later updates >> however is there a way of getting around it without going all over >> again and remain with 8.3.1 database where I have already put alot of >> important data. > > Why don't you use the latest 8.3.x release? You don't need a dump and > restore to go from 8.3.1 to 8.3.latest. > > A > > -- > Andrew Sullivan > ajs@commandprompt.com > +1 503 667 4564 x104 > http://www.commandprompt.com/ > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/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@commandprompt.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@commandprompt.com +1 503 667 4564 x104 http://www.commandprompt.com/
Andrew Sullivan wrote: > 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@commandprompt.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. \x09 is a tab. I think this behavior was changed in 8.3.something (made it display as actual tabs instead of escaping them) -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Andrew Sullivan wrote:
>> 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.
> \x09 is a tab. I think this behavior was changed in 8.3.something (made
> it display as actual tabs instead of escaping them)
Note that that's a psql behavior not a backend behavior. I wonder if
the OP updated his server but is still using 8.3.early psql.
regards, tom lane