Quick Links

[ADMIN] what's the efficient/safest way to convert database character set ?

From:	"Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com>
To:	"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject:	[ADMIN] what's the efficient/safest way to convert database character set ?
Date:	2013-10-17 22:13:43
Message-ID:	D83E55F5F4D99B4A9B4C4E259E6227CD9DF12A@AUX1EXC01.apac.experian.local
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi,

I've got a question of converting database from ascii to UTF-8, what's the best approach to do so if the database size is very large? Detailed procedure or experience sharing are much appreciated!

Thanks,
Suya

Responses

Re: [ADMIN] what's the efficient/safest way to convert database character set ? at 2013-10-18 00:07:33 from Steve Atkins
Re: [ADMIN] what's the efficient/safest way to convert database character set ? at 2013-10-18 00:23:20 from John R Pierce

Browse pgsql-general by date

	From	Date	Subject
Next Message	Huang, Suya	2013-10-17 22:15:02	Re: werid error"index row size 3040 exceeds btree maximum, 2712" occur randomly
Previous Message	Merlin Moncure	2013-10-17 21:57:44	Re: How do I create a box from fields in a table?