pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMigration problems with encoding.
3+ messages / 3 participants
[nested] [flat]
* Migration problems with encoding.
@ 2006-12-12 09:47 Manuel Trujillo <mtrujillo@vlex.com>
2006-12-12 09:57 ` Re: Migration problems with encoding. Shoaib Mir <shoaibmir@gmail.com>
2006-12-12 15:38 ` Re: Migration problems with encoding. Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 3+ messages in thread
From: Manuel Trujillo @ 2006-12-12 09:47 UTC (permalink / raw)
To: pgsql-admin
Hi!
Firs, I will apologize about my bad english... sorry...
I have a database in postgres 8.0 with encoding defined with UTF8. All
work fine, but because the new features from 8.2 version, we would like
to migrate the database to this new version.
The problem: Encoding incompatibilities between the postgresql version.
How can i resolve this with a database about 16 Gb? Are there any
document about how to solve this?
Thank you very much.
--
Manuel Trujillo Albarral
Responsable de Sistemas
VLEX NETWORKS S.L.
Telf: 93-272.26.85 ext. 111
Jabber/GoogleTalk manu.trujillo@gmail.com
http://www.vlex.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Migration problems with encoding.
2006-12-12 09:47 Migration problems with encoding. Manuel Trujillo <mtrujillo@vlex.com>
@ 2006-12-12 09:57 ` Shoaib Mir <shoaibmir@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Shoaib Mir @ 2006-12-12 09:57 UTC (permalink / raw)
To: Manuel Trujillo <mtrujillo@vlex.com>; +Cc: pgsql-admin
Have you tried using 'iconv' for cleaning up the invalid UTF8 character? In
case of big files you can always split them.
-----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/12/06, Manuel Trujillo <mtrujillo@vlex.com> wrote:
>
> Hi!
>
> Firs, I will apologize about my bad english... sorry...
>
> I have a database in postgres 8.0 with encoding defined with UTF8. All
> work fine, but because the new features from 8.2 version, we would like
> to migrate the database to this new version.
> The problem: Encoding incompatibilities between the postgresql version.
>
> How can i resolve this with a database about 16 Gb? Are there any
> document about how to solve this?
>
> Thank you very much.
>
> --
> Manuel Trujillo Albarral
> Responsable de Sistemas
> VLEX NETWORKS S.L.
> Telf: 93-272.26.85 ext. 111
> Jabber/GoogleTalk manu.trujillo@gmail.com
> http://www.vlex.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Migration problems with encoding.
2006-12-12 09:47 Migration problems with encoding. Manuel Trujillo <mtrujillo@vlex.com>
@ 2006-12-12 15:38 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2006-12-12 15:38 UTC (permalink / raw)
To: pgsql-admin; +Cc: Manuel Trujillo <mtrujillo@vlex.com>
Manuel Trujillo wrote:
> The problem: Encoding incompatibilities between the postgresql
> version.
In detail?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-12-12 15:38 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-12 09:47 Migration problems with encoding. Manuel Trujillo <mtrujillo@vlex.com>
2006-12-12 09:57 ` Shoaib Mir <shoaibmir@gmail.com>
2006-12-12 15:38 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox